Working with multi-member files using SQL

View some of the Frequently Asked Questions to our support staff. Included are some tips and tricks making this forum ideal for users getting started with GoAnywhere Director. Note: Users can reply to existing topics but only our support staff can add new topics to this forum.

Working with multi-member files using SQL

Postby Support_Julie » Mon Mar 23, 2009 1:18 pm

You can work with multi-member files using SQL in the following way –

Call a system procedure to override the default (*FIRST) member (just for this job)
Run the SQL Select statement in the usual way
Call another system procedure to reset the default member to what it was.

Below is an example:


/* Override to the member (the second parm must be the exact length of the string) */

CALL QSYS.QCMDEXC('OVRDBF FILE(file) TOFILE(library/file) MBR(member) OVRSCOPE(*JOB)', 0000000065.00000)


The number 0000000065.00000 is the length of the command in RED

/* Select records from the member */

SELECT * FROM file;

/* Delete the override to the member */

CALL QSYS.QCMDEXC('DLTOVR FILE(file) LVL(*JOB)', 0000000027.00000);


The number 0000000027.00000 is the length of the command in RED

In essence, you will have 3 Query Elements in your SQL Task, with the first query to override the default member name, the second to run the actual query and the third to delete the override.
Julie
Software Support
Linoma Software
Support_Julie
Support Specialist
 
Posts: 75
Joined: Thu Mar 05, 2009 3:49 pm
Location: Ashland, NE USA

Return to Knowledge Center

Who is online

Users browsing this forum: No registered users and 1 guest

cron