Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Query Support in Syncsort's SYNCTOOL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
ParagChouguley

Active User


Joined: 03 Feb 2007
Posts: 175
Location: PUNE(INDIA)

PostPosted: Mon Jun 30, 2008 4:25 pm    Post subject: DB2 Query Support in Syncsort's SYNCTOOL
Reply with quote

Is DB2 Query Support available in Syncsort's SYNCTOOL ???
If yes, how to use it ?
Can I get sample JCL ?
Back to top
View user's profile Send private message

Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2180
Location: @my desk

PostPosted: Mon Jun 30, 2008 6:24 pm    Post subject:
Reply with quote

Which version of syncsort do you have?. Query support is available from 1.2, If I remember correctly.

Thanks,
Arun
Back to top
View user's profile Send private message
ParagChouguley

Active User


Joined: 03 Feb 2007
Posts: 175
Location: PUNE(INDIA)

PostPosted: Mon Jun 30, 2008 7:06 pm    Post subject:
Reply with quote

Yes ! Its 1.2 !
Also DB2 support works with PGM=SYNCSORT, but I need to know how it works with SYNCTOOL
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Mon Jun 30, 2008 9:45 pm    Post subject:
Reply with quote

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
View user's profile Send private message
ParagChouguley

Active User


Joined: 03 Feb 2007
Posts: 175
Location: PUNE(INDIA)

PostPosted: Tue Jul 01, 2008 11:14 am    Post subject:
Reply with quote

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
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Tue Jul 01, 2008 9:26 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Join in SQL Query vickey_dw DB2 2 Tue Jan 17, 2017 12:15 am
This topic is locked: you cannot edit posts or make replies. MQ setup query mohitsaini Java & MQSeries 4 Sun Jan 08, 2017 1:53 am
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us