Search found 265 matches

by sshettar
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

i'm sorry about my typo

we are running on 4 nodes
by sshettar
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

We are using running on nodes

and i have given this constraint in the transformer

the job is this way

seq file ------ Transformer--------seq file
by sshettar
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
by sshettar
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...
by sshettar
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...
by sshettar
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

Well my data dint have any decimal point

Hence i put in a decimal point in order to make it easy for transformer to read it as decimal

Hope i cleared your doubt
by sshettar
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...
by sshettar
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

I'm sorry my output should look like
1124600 not 0077700
hence the start position is 78
by sshettar
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

Thanks for the reply

I did try adding it to
StringToDecimal(DSLink2.VISIONDATA[78,7],'ceil')

But no change
it still reads '00000.00'
by sshettar
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 ...
by sshettar
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...
by sshettar
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 ...
by sshettar
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...
by sshettar
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

Thanks Craig , it did work!!!!!

Thank You
by sshettar
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

Thanks Craig , it did work!!!!!

Thank You