SQLJ is a standard that defines a syntax for embedding SQL statements into java source code. The embedded SQL statements are called SQLJ statements. SQLJ requires a special source file type with the extension .sqlj.
The SQLJ translator translates the SQLJ source files to Java source files in which the SQLJ statements are replaced by calls to the SQLJ runtime. The translator performs checks on the embedded SQL statements, which are checked for conformance with the Open SQL grammar. Schema checking is also performed against an offline catalog. The offline catalog consists of files (extension .gdbtable), each describing a table. The offline catalog files can be generated using the Dictionary table editor.
The translation and checking functions are part of the SAP NetWeaver Developer Studio.
· Find SQL errors at design time.
· Display translation errors and Java compile errors, and navigate to the relevant part of the SQLJ source file.
· Set breakpoints in the SQLJ source file.