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 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: 2285
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 Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts Technical Support Engineer (DB2 on z/... Kenneth Barton Lasky Mainframe Jobs 0 Fri Aug 25, 2017 12:14 am
No new posts Can we limit length in concatenation ... balaji81_k DB2 7 Tue Aug 22, 2017 2:50 am
No new posts RFE: DB2 support for mixed case names. Pedro DB2 0 Tue Jul 04, 2017 1:32 am

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