Documentation‎ > ‎

Admin tasks

Allow to create, delete a test SQL Select request from a 5250 session.
To complete this tasks is required:
  • 5250 terminal session.
  • A user profile with *USE auth to SABXML Objects
  • SABXML user profile must need a *READ auth to file/s described on SQL Select.
  • Ensure SABXML library are on library list. Use ADDLIBLE SABXML command.

Add SQL request (ADDRQS)

Use ADDRQS command to add a SQL Select request managed by SABXML Server.

ADDRQS ID(CUSTOMERS)                             
       TEXT(
'Customers list')                    
       SQLSELECT(
'select * from adtslab.customer')
       WRITER(
'SAB_XML')                      
       LIMIT(
*NOMAX)                             
       XSLT(
*NONE)                               
       OVERRIDE(
*NO)

ID, Unique ID of the request (like tag or identification)
TEXT, description.
SQLSELECT, SQL SELECT Request using standar *SQL and max length 5000 Characters.
WRITER, program used for writing / format the XML file
LIMIT, Number of max rows allowed to retrieve
XSLT, XLST stylesheet, optional, to include on the header of the XML file
OVERRIDE, When request is running, allow to use a different writer, modify limit rows returned or use other stylesheet.

Errors:
  • SAB1001 Identification request not valid.
  • SAB1002 Text description not valid.
  • SAB1003 Missing SQL Select request.
  • SAB1004 "WRITER" is not a registred SAB_writer.

Remove SQL request (DLTRQS)

Use DLTRQS to remove a SQL request

DLTRQS ID(
CUSTOMERS)

ID, Unique ID of the request (like tag or identification)

Errors:

None

(ToDo List): At this moments there is no option to change SQL request.
A possible workaround its remove and re-add a SQL request.

Run SABXML request (RUNRQS)

This command is a easy option to test a SQL request.

SABXML command allow to test a combinations into ID request and writers available.
On this example XML file are generated with SAB_XMLIFS writer at /tmp/sabxml.xml:

SABXML ID (CUSTOMERS) WRITER (SAB_XMLIFS)

Parameters

ID, Unique ID of the request (like tag or identification)
WRITER, program used for writing / format the XML file

Errors:

     * CPD0170 not found the program "writer"

Record SAB_Writer program (RCDWRT)

This command record a program name as valid SAB_writer.
This is a security layer on SABXML server to prevent malicious program not registred as SAB_writer.
Note: The program must start with SAB_ characters and must be stored at library SABXML

Comments