Hi,
Is 22. decimal or not?. If it is a decimal how do i check?
TIA
Search found 50 matches
- Wed Jul 13, 2005 10:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Decimal Check
- Replies: 2
- Views: 1300
- Wed Jul 06, 2005 10:34 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: reading sequential file
- Replies: 8
- Views: 3960
- Wed Jul 06, 2005 7:48 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: reading sequential file
- Replies: 8
- Views: 3960
- Tue Jul 05, 2005 7:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: reading sequential file
- Replies: 8
- Views: 3960
Re: reading sequential file
how do convert that array into a single string with some delimiter or new line as delimiter character?.
Ans = Convert(@VM,"0A",Ans)
Is above works?
TIA
Ans = Convert(@VM,"0A",Ans)
Is above works?
TIA
- Tue Jul 05, 2005 4:44 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: reading sequential file
- Replies: 8
- Views: 3960
reading sequential file
Hi, i wrote a routine which reads the sequential file and gives the output in a array.In this routins i have used Ans<-1> so that it reads the each record in new line. I want to pass this routine output to Start loop activity which accepts a input as a Comma,Space or other delimited string. My quest...
- Fri Jun 24, 2005 5:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: merge
- Replies: 7
- Views: 2521
- Thu Jun 23, 2005 2:24 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: merge
- Replies: 7
- Views: 2521
- Tue Jun 21, 2005 3:14 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: merge
- Replies: 7
- Views: 2521
merge
Hi, I am using the Merge stage.and i have set the 'pure inner join'. Merge-------->Transformer---->seq_file. when i run this job i got an error saying that 'FUNCTION get_next_output_row' failed. [Input file : xyz.TXT] End of row termination characters expected. where do i set these properties?.any h...
- Thu Jun 16, 2005 2:17 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: debugging
- Replies: 4
- Views: 1477
debugging
Hi,
How can i debug a sequencer job?.
any help would be appreciated.
TIA
How can i debug a sequencer job?.
any help would be appreciated.
TIA
- Thu Jun 09, 2005 6:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: StoredProcedure Stage in DS7.5
- Replies: 1
- Views: 984
StoredProcedure Stage in DS7.5
Hi,
Is StoredProcedure Stage in DS7.5 supports SQL Server StoredProcedures?.
TIA
Is StoredProcedure Stage in DS7.5 supports SQL Server StoredProcedures?.
TIA
- Wed Jun 08, 2005 8:30 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Validation
- Replies: 2
- Views: 1222
Validation
Hi,
Iam using the following code Numeric validation.
If Oconv(Trim(InputLink.Col),"MCN") = Trim(InputLink.Col) Or Index(InputLink.Col,'E',1) >=1 Or Index(InputLink.Col,'e',1) >=1 Or InputLink.Col <>'' Then InputLink.Col Else 'Error'
Is the right approach?.
TIA
Iam using the following code Numeric validation.
If Oconv(Trim(InputLink.Col),"MCN") = Trim(InputLink.Col) Or Index(InputLink.Col,'E',1) >=1 Or Index(InputLink.Col,'e',1) >=1 Or InputLink.Col <>'' Then InputLink.Col Else 'Error'
Is the right approach?.
TIA
- Tue Jun 07, 2005 11:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: VOC
- Replies: 1
- Views: 921
VOC
Hi,
- Mon Jun 06, 2005 2:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Trigger Expression
- Replies: 4
- Views: 1493
- Mon Jun 06, 2005 12:53 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Trigger Expression
- Replies: 4
- Views: 1493
Trigger Expression
Hi, I have 5 Job Activities in a sequence job.And I have declares a Job Parameter. Based on the Job Parameter value, From the job Activity1, it will trigger the Job Activity2 or Job Activity3.Here, I have written a Trigger Expression like Substrings(jobparameter,1,3)='xyz' It should trigger a Job Ac...
- Thu Jun 02, 2005 11:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Counting No Of Lines
- Replies: 10
- Views: 3484
Counting No Of Lines
Hi ,
I would like count the no of lines in a text file.
Iam using the 'cat filename | wc -l' which returns the no of lines.
But Before that i need to eliminate the empty lines in the text file.
how can i achieve this?.
Any help would be appreciated.
TIA
I would like count the no of lines in a text file.
Iam using the 'cat filename | wc -l' which returns the no of lines.
But Before that i need to eliminate the empty lines in the text file.
how can i achieve this?.
Any help would be appreciated.
TIA