Search found 67 matches

by DSkkk
Thu Dec 16, 2004 2:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: the number of records
Replies: 7
Views: 2536

actually my source is in XML and we convert it into flat files using a Loadscript. the header will have record count in it. if i use wc -l then the header also gets counted and it will not show zero rows in it. can i create a sequence where i can get the count gives no of rows because datastage grab...
by DSkkk
Thu Dec 16, 2004 11:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to abort a job in a routine if the source file is empty?
Replies: 8
Views: 3131

i need to abort the job if there are no records in it. i get a header which gives the rowcount but i do not know where and how to compare this. if this is 0 then the job should stop abort.
can you please help me.
by DSkkk
Wed Dec 15, 2004 8:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: the number of records
Replies: 7
Views: 2536

i meant that the records are equal to zero then the job should not continue to run.

is DSExecute used in unix??
but i want to get the number of records in datastage compare it then proceed(data stage is in windows environment)
by DSkkk
Wed Dec 15, 2004 6:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: unwanted characters
Replies: 1
Views: 751

unwanted characters

hi, my sources are XML files and we have a style sheet and a script which convert the XML into pipelimited flat files. but when ihave some extra characters in the XML files it is still getting parsed in the same way and converting into a flat file. i need a shell script which deletes unwanted charac...
by DSkkk
Wed Dec 15, 2004 6:23 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: the number of records
Replies: 7
Views: 2536

the number of records

hi, i need a routine to count the number of records in the input file. if the number of records in a file is less than zero then my further sequence should stop from running. i get a failure when there is no file at all but my sequence should stop when there is a file with zero records. if a job run...
by DSkkk
Thu Nov 11, 2004 9:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: how do i import .dsx file
Replies: 2
Views: 3600

how do i import .dsx file

hi
i have a .dsx file. all i want is to import it and plug it to the job i developed and work it out.
how do i do that. plz. give me suggestions.
thanks.
kkk
by DSkkk
Mon Nov 08, 2004 10:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: doubt in MQ STAGE
Replies: 1
Views: 697

doubt in MQ STAGE

hi,
i have one doubt.
1) is it necessary for the MQ stage to read all the fields of the message before deleting that message.

2) is it possible that a part of the message be deleted from the message instead of the entire message in the process of reading the message