Search found 320 matches

by mydsworld
Fri Aug 15, 2008 11:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: About MVS edition
Replies: 7
Views: 3288

So, is there any way to call remote Mainframe job from sitting on DS on Unix.
by mydsworld
Fri Aug 15, 2008 10:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: About MVS edition
Replies: 7
Views: 3288

I have DS 8 running on Unix. Can I call Mainframe jobs.
by mydsworld
Thu Aug 14, 2008 3:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP Query
Replies: 7
Views: 2551

FTP job runs but didn't find any file.
by mydsworld
Thu Aug 14, 2008 11:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP Query
Replies: 7
Views: 2551

Actually I need this WFF stage as I have two links from WFF.

1. When FTPed file not found in local directory
2. When FTPed file found in local directory.
by mydsworld
Thu Aug 14, 2008 10:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Processing XML files
Replies: 5
Views: 1655

I have requirement where Datastage is just needed to FTP a XML file from some source server to target server and do no processing of the XML.

Whats the most efficient way to do this. What should I use in FTP stage metadata. Will it be XSDL definition or just a huge size varchar column ?
by mydsworld
Thu Aug 14, 2008 9:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP Query
Replies: 7
Views: 2551

I understand the concept of Trigger file. The problem would have been with that when I have something : Wait for File -> Other jobs Then 'Wait for file' takes up the partially received file and start calling other jobs. But here I am invoking the 'Wait for file' activity stage only after the success...
by mydsworld
Tue Aug 12, 2008 1:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: FTP Query
Replies: 7
Views: 2551

FTP Query

I have a Sequence like this : Job1 (FTP job doing GET/PULL) -> Wait for file ->....other jobs Now the trigger condition on Job1 is 'Success'/'Warning'. So, will there be any possibility where partially transferred file be taken up for processing by 'Wait for File' activity stage. My intension is to ...
by mydsworld
Mon Aug 11, 2008 2:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To abort a job for reject records
Replies: 7
Views: 1741

Without using an 'Otherwise' link in Transformer, I would like to abort a job whenever there is certain records in a Reject Link.
Is that possible ?
by mydsworld
Thu Aug 07, 2008 9:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Processing XML files
Replies: 5
Views: 1655

Processing XML files

If I need to FTP (get) a XML file from remote server and process, how should my job look like :

FTP Ent -> XML Input -> Seq File
by mydsworld
Mon Aug 04, 2008 8:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Join stage giving Null's
Replies: 6
Views: 1580

Yes, left & right links are verified & the way I have described earlier.
by mydsworld
Mon Aug 04, 2008 7:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Join stage giving Null's
Replies: 6
Views: 1580

Partition & sorting both are performed on (Join) key field 'XYZ'.
by mydsworld
Sun Aug 03, 2008 8:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Join stage giving Null's
Replies: 6
Views: 1580

Join stage giving Null's

I am facing a problem with Join stage doing a 'Left outer' join shown below : Seq File (L) ---| |----Join ----> DB2 API (R) ---| Both the inputs are explicitly Hash partitioned and (stable) sorted. Say, I am joining on a key field 'XYZ' (trimmed).In Join output, I am selecting a field 'MNP' from rig...
by mydsworld
Fri Aug 01, 2008 10:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Writting into Mainframe GDG
Replies: 11
Views: 4135

I am very new to Mainframe & haven't come across this term GDG before.

Could you plz tell me :

1. What do these parameters RECFM=VB and LRECL=256 suggest.
2. What is meant by <GDG Name>(+1)
by mydsworld
Fri Aug 01, 2008 8:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Writting into Mainframe GDG
Replies: 11
Views: 4135

Thanks again.

Please explain the following lines :

1. quote site RECFM=VB LRECL=256

Is it setting some parameter before FTP?

2. put $UnixFileName $vMVS

Is $vMVS the GDG name ?
by mydsworld
Fri Aug 01, 2008 8:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Writting into Mainframe GDG
Replies: 11
Views: 4135

Thanks for your reply.

Could you plz tell me where shd I mention the GDG name in FTP stage, I think it is not in URI.