i'm sorry about my typo
we are running on 4 nodes
Search found 265 matches
- Tue Aug 26, 2008 10:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with @OUTROWNUM
- Replies: 6
- Views: 1607
- Tue Aug 26, 2008 8:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with @OUTROWNUM
- Replies: 6
- Views: 1607
- Tue Aug 26, 2008 8:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with @OUTROWNUM
- Replies: 6
- Views: 1607
Issue with @OUTROWNUM
Hi All,
I have this job where i'm trying to restrict the number of records written to a file .
I tried givng the constraint to that link as
@OUTROWNUM =1
But i see 2 records getting written to the file
I dont understand whats going wrong
Any input is highly appreciated
Thanks
I have this job where i'm trying to restrict the number of records written to a file .
I tried givng the constraint to that link as
@OUTROWNUM =1
But i see 2 records getting written to the file
I dont understand whats going wrong
Any input is highly appreciated
Thanks
- Fri Aug 22, 2008 1:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Converting string to signed decimal
- Replies: 1
- Views: 717
Converting string to signed decimal
Hi All, I have this job where i am reading a file as one column and parse the file into several columns. when i am parsing the file i have to create this one column which should be in signed decimal form the data looks like this 000000{ and this should be stored as signed decimal How do i accomplish...
- Fri Aug 22, 2008 7:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with combining diff columns frm diff files into 1 file
- Replies: 1
- Views: 595
Issue with combining diff columns frm diff files into 1 file
Hi All, I have this job where each record in the input file has its own record type for example 'AA0' , BA0', 'CA0', 'DA0', 'EA0' , 'FA0'.my output file has columns which is derived from each of these records but the count of these records for each record type is different for example record with re...
- Thu Aug 21, 2008 2:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with String to decimal
- Replies: 9
- Views: 27361
- Thu Aug 21, 2008 2:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with String to decimal
- Replies: 9
- Views: 27361
Thank for all the prompt replies Well i found a work around for this I instead did the following in the derivation for the field i gave DSLink2.VISIONDATA[78,5]:'.':DSLink2.VISIONDATA[83,2] and i read it as decimal 7.2 It worked for though tis giving me the output i wanted ie 00777.00 Dont know if t...
- Thu Aug 21, 2008 12:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with String to decimal
- Replies: 9
- Views: 27361
- Thu Aug 21, 2008 12:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with String to decimal
- Replies: 9
- Views: 27361
- Thu Aug 21, 2008 11:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with String to decimal
- Replies: 9
- Views: 27361
Problem with String to decimal
Hi All, I have this job which is reading data as just one column I parsed this filed based on the specified fields I have this one field which should be of type decimal [7,2] But when i convert the string to decimal it is giving as '0000.00' though there is other values in it here's one example the ...
- Wed Aug 20, 2008 7:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading the sequential File
- Replies: 1
- Views: 1059
Reading the sequential File
Hi All, I have this one record which is about 320 bytes long , all i have to do is sparse this file into specified fields. I have defined two columns reading this one whole record and create another one which gets a default date . Now in my next job i sparse this one record into specified fields and...
- Mon Aug 11, 2008 2:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help in writing a routine
- Replies: 3
- Views: 1295
Help in writing a routine
Hi All, I am developing a sequence in which i am using a user activity stage to pass the parameter values to allmy jobs. i needed a function getparamvalue() to get the parameter value defined in the file. i have never writen a routine and even if i have to try i dont know where to write the routine ...
- Mon Aug 11, 2008 9:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How toUse User Variable Activity Stage
- Replies: 2
- Views: 2024
How toUse User Variable Activity Stage
Hi All, I have not used a User Variable Activity Stage yet. I wanted to know how to use this stage i have a little knowledge about it but i'm not able to prceed further due to lack of information I know we would have to declare all the parameters in a file with all its values & in the User Varia...
- Thu Aug 07, 2008 12:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Running scripts
- Replies: 4
- Views: 1453
- Thu Aug 07, 2008 12:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Running scripts
- Replies: 4
- Views: 1453