Search found 53 matches

by shrinivas
Tue May 15, 2007 10:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing in to a sequential file trhru routine
Replies: 22
Views: 10679

I tried every thing(in my view).. I can tell you guys my requirments .. I have a variable having a string and I would like to write in to a file . The string looks like a,b,10,11Char(10):Char(13)c,d,12,93Char(10):Char(13)d,e,20,12Char(10):Char(13) I am appending Char(10):Char(13) to get the values i...
by shrinivas
Tue May 15, 2007 8:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing in to a sequential file trhru routine
Replies: 22
Views: 10679

even for the simple transform routine I am getting the same problem #Include DSINCLUDE DSD_STAGE.H #Include DSINCLUDE JOBCONTROL.H #Include DSINCLUDE DSD.H #Include DSINCLUDE DSD_RTSTATUS.H ErrorCode=0 set='' destset= Arg1 Status = "abcd,122,11" OPENSEQ destset TO FileVar1 THEN WRITESEQ St...
by shrinivas
Tue May 15, 2007 8:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing in to a sequential file trhru routine
Replies: 22
Views: 10679

I removed it but , no change , I am getting the CR at same place
by shrinivas
Tue May 15, 2007 7:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing in to a sequential file trhru routine
Replies: 22
Views: 10679

Its coming in the last row of the file and it is the last character of the row. For example ........ The file structure looks like .... JobName , SrcRowCount, DestRowCount A,10,10 B,10,10 C,20,11 So the Carraiage Return is concatenated with the number 11[Last row Last Character] When I see the Ascii...
by shrinivas
Tue May 15, 2007 7:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing in to a sequential file trhru routine
Replies: 22
Views: 10679

Ya Chulett I just got to know its the ASCII value of "CR" from DS documents ..
I write the Ascii values into a sequential file.There its returning 0D.
by shrinivas
Tue May 15, 2007 6:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing in to a sequential file trhru routine
Replies: 22
Views: 10679

Hi guys ,
I am writing a file thru a sequence
In th eabove message I have written I am writing a file thru a sequence.
Its a typo and the correct sentence is "I am writing a file thru a routine."
by shrinivas
Tue May 15, 2007 4:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing in to a sequential file trhru routine
Replies: 22
Views: 10679

Writing in to a sequential file trhru routine

Hi guys , I am writing a file thru a sequence. This is basicly a control routine which accepts list of job names and write output in a sequential file . The problem I am facing is whenever I write the target sequential file , Every time the last character of the sequentail file is appended with a ju...
by shrinivas
Fri Apr 13, 2007 5:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Write a delimeted string in to a sequential file thru routin
Replies: 5
Views: 2187

Its working Thank u Anupam ,

YOU ROCKS :D
by shrinivas
Fri Apr 13, 2007 4:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Write a delimeted string in to a sequential file thru routin
Replies: 5
Views: 2187

Its a control Routine where I am writng the status of jobs in the sequential file .The routine fetch the starttime and status of all jobs in my project. All status stored in a single variable with deimeter ";". but when i write in to sequntial file I want them in to diffrent lines as I men...
by shrinivas
Thu Apr 12, 2007 11:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Write a delimeted string in to a sequential file thru routin
Replies: 5
Views: 2187

In the above example the delimeter is ";"
by shrinivas
Thu Apr 12, 2007 11:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Write a delimeted string in to a sequential file thru routin
Replies: 5
Views: 2187

Write a delimeted string in to a sequential file thru routin

Hi guys, My requirment is I have to write a delimeted string in to a sequntial file thru routine. Each delimeted value has to be written in a new line. For example String is "ab,bc,cd;lm,mn,no;uv,wx,yz;" So my output in the file should be ab,bc,cd lm,mn,no uv,wx,yz. How can I achive it. An...
by shrinivas
Thu Mar 08, 2007 7:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Row count of a link
Replies: 24
Views: 21644

Ya Srinath , I was giving passive stage name values. after your suggestion when I gave an active stage which is transformer in my case, It's working fine and giving me the appropriate ans . But still I am wondering why it was working when I am trying it thru DS manager. Thanks Kumar nad Srianth for ...
by shrinivas
Thu Mar 08, 2007 5:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Row count of a link
Replies: 24
Views: 21644

Ya i am writng the return value in a file , I have used a tranformer where i call the routine in a stage variable and then passing the return value into a sequential file . I checked the same with writing a simple routine , in which I have hard coded ever thing including Job name, stage name and lin...
by shrinivas
Thu Mar 08, 2007 5:11 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Row count of a link
Replies: 24
Views: 21644

I tried hardcoding the values , I even checked for the bad handles, Bad Instances ....... etc....Still getting the rowcount as zero.. Kumar , remeber you suggested me the post yesterday...What was the solution for that topic, I am unable to see that , as i dont have a premium account
by shrinivas
Thu Mar 08, 2007 4:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Row count of a link
Replies: 24
Views: 21644

Ya , Statistics turn to green and shows the number of rows/sec processed. Even I can see the number of rows processed in the DS Director -> Monitor when I right click on the job and select Monitor.