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: 2238
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 Why TS/OP would Not contact site supp... RahulG31 All Other Mainframe Topics 2 Wed Mar 22, 2017 7:46 am
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Omegamon for DB2 query ashek15 DB2 0 Wed Feb 15, 2017 11:25 am
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm


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