View previous topic :: View next topic
|
Author |
Message |
ParagChouguley
Active User
Joined: 03 Feb 2007 Posts: 175 Location: PUNE(INDIA)
|
|
|
|
Is DB2 Query Support available in Syncsort's SYNCTOOL ???
If yes, how to use it ?
Can I get sample JCL ? |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Which version of syncsort do you have?. Query support is available from 1.2, If I remember correctly.
Thanks,
Arun |
|
Back to top |
|
|
ParagChouguley
Active User
Joined: 03 Feb 2007 Posts: 175 Location: PUNE(INDIA)
|
|
|
|
Yes ! Its 1.2 !
Also DB2 support works with PGM=SYNCSORT, but I need to know how it works with SYNCTOOL |
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
ParagChouguley wrote: |
I need to know how it works with SYNCTOOL |
When a SORT or COPY DB2 Query application is invoked from a program (i.e., SYNCTOOL), specify the DB2 parameter in the $ORTPARM DD statement.
Just out of curiosity, why is SYNCTOOL required? Is this an existing application that you want to add a DB2 Query component? If so, could the SYNCTOOL application be converted to a SORT application? |
|
Back to top |
|
|
ParagChouguley
Active User
Joined: 03 Feb 2007 Posts: 175 Location: PUNE(INDIA)
|
|
|
|
Quote: |
When a SORT or COPY DB2 Query application is invoked from a program (i.e., SYNCTOOL), specify the DB2 parameter in the $ORTPARM DD statement
|
I didnot understand this. Moreover, I execute SYNCTOOL thru JCL.
Quote: |
Just out of curiosity, why is SYNCTOOL required? Is this an existing application that you want to add a DB2 Query component? If so, could the SYNCTOOL application be converted to a SORT application?
|
There is no such perticular application I require this for. As a matter of curiosity I was just looking for it. Also I always prefer SYNCTOOL over simple sort as it allows multiple sorting/copying in a single step. |
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
ParagChouguley wrote: |
Quote: |
When a SORT or COPY DB2 Query application is invoked from a program (i.e., SYNCTOOL), specify the DB2 parameter in the $ORTPARM DD statement
|
I didnot understand this. Moreover, I execute SYNCTOOL thru JCL.
|
To initiate a SORT or COPY with the DB2 Query facility using job control statements, specify PARM='DB2=dsn' on the EXEC statement. (The dsn referred to in the DB2 parameter is the DB2 subsystem name to be accessed).
Code: |
//STEP1 EXEC PGM=SYNCSORT,PARM='DB2=DSN1' |
However, when a program other than SYNCSORT (or one of its aliases) is being executed, the DB2 parameter must be specified on the $ORTPARM DD statement:
Code: |
//STEP1 EXEC PGM=SYNCTOOL
//$ORTPARM DD *
DB2=DSN1 |
Hope this clarifies it for you. |
|
Back to top |
|
|
|