Search found 50 matches

by pandu80
Sun May 08, 2005 6:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Warning Message
Replies: 3
Views: 844

Warning Message

Hi,
I have 40 jobs in a sequencer.I want to capture the only warnings after end of all the jobs.

Any clues please.

TIA.
by pandu80
Sun May 08, 2005 3:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Seq_File
Replies: 12
Views: 4871

hi For sorting thw input data, I have searched this forum and i found sort -k 1, 1n -k 2, 2n something like this. In this is 'k' s the key column name, 1 is the column position and 1n indicates the column is numeric. Is my assumption is correct or not?. Could anybody explain me some more pls. TIA Hi...
by pandu80
Fri May 06, 2005 6:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Seq_File
Replies: 12
Views: 4871

Seq_File

Hi, I have a seq file like X008999999999999999999 001 Y008999999999999999999 001 Y008999999999999999999 002 Y008999999999999999999 003 X008999999999999999999 002 Y008999999999999999999 001 Y008999999999999999999 002 Y008999999999999999999 002 Y008999999999999999999 004 Y008999999999999999999 005 X00...
by pandu80
Sat Apr 23, 2005 7:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Email from DS stage
Replies: 4
Views: 2182

Re: Email from DS stage

OR create a sequential file with the color code = red . Then write a routine to count the no of rows in that file. From the Routine Activity call this routine and if Return Value is >=0 call Notification Activity. Then u wil be all set Thanks Hi , Is there any way to send email from DS based on some...
by pandu80
Tue Apr 19, 2005 9:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SEQ_FILE
Replies: 7
Views: 2470

sorry. ray let me put my requirement in right way. my requirement is, X--->Y---->Z 'X' IS PARENT FOR 'Y' AND 'Y' IS PARENT FOR 'Z' SO IN VALID COMBINTAIONS ARE X Z-------> THERE IS NO PARENT RECORD FOR 'Z' Y Z-------> THERE IS NO PARENT RECORD FOR 'Y' Z-------> THERE IS NO PARENT RECORD FOR 'Z' IN T...
by pandu80
Mon Apr 18, 2005 6:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SEQ_FILE
Replies: 7
Views: 2470

Ray,
Iam not able to make that logic.
could yo please explain me bit more.

TIA.
by pandu80
Mon Apr 18, 2005 6:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SEQ_FILE
Replies: 7
Views: 2470

Hi,
After 'x' record there should be atleast one 'Y' and one 'Z" record.If there is no 'Y' and 'Z' records for the corresponding 'X' record i want to reject the file.

TIA
by pandu80
Mon Apr 18, 2005 6:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SEQ_FILE
Replies: 7
Views: 2470

SEQ_FILE

HI, I HAVE A SEQFILE X008999999999999999999 Y008999999999999999999 Z008999999999999999999 Z008999999999999999999 X008999999999999999999 Y008999999999999999999 Z008999999999999999999 Y008999999999999999999 Z008999999999999999999 Z008999999999999999999 X008999999999999999999 Y008999999999999999999 Z00...
by pandu80
Sat Apr 16, 2005 1:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Oracle
Replies: 2
Views: 672

Oracle

Hi, When iam trying to load the data to oracle table it throws the error xyz..Transformer_1: ORA-01438: value larger than specified precision allows for this column. But i have checked the datatype and length of that field and it is Decimal and Precision 9. When i tried to insert the '1' also it thr...
by pandu80
Fri Apr 15, 2005 1:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: lookup
Replies: 3
Views: 624

lookup

HI,
I HAVE A SEQFILE AS SOURCE AND LOOKUP_HSH FILE.
CAN I WRITE " X OR Y OR Z" IN THE EXPRESSION EDITOR of hsh_file when iam comparing the value of input stream into lookup hsh file.

TIA
by pandu80
Thu Apr 14, 2005 7:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Phantom Error
Replies: 1
Views: 992

Phantom Error

Hi

What is Phantom Error?.wwhy do we get this error?.

TIA
by pandu80
Thu Apr 14, 2005 7:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: seqfile
Replies: 1
Views: 535

seqfile

HI, I HAVE A SEQFILE 1008999999999999999999 1008999999999999999999 1008999999999999999999 2008999999999999999999 2008999999999999999999 2008999999999999999999 2008999999999999999999 3008999999999999999999 3008999999999999999999 3008999999999999999999 3008999999999999999999 3008999999999999999999 IF ...
by pandu80
Tue Apr 12, 2005 7:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: RANGE LOOKUP
Replies: 1
Views: 1126

RANGE LOOKUP

IS IT POSSIBLE TO CHECK THE THE RANGE IN HASHFILE LOOKUP?


TIN
by pandu80
Tue Apr 12, 2005 5:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SEQFILE
Replies: 4
Views: 1301

Hi, ----------------SEQ_FILE(WITH 90%RECORDS) | | SEQ_FILE-------------->XFM------------->SEQ_FILE(WITH 10 % RECORDS) ^ | |LOOKUP_HSH I AM GIVING THE CONSTRAINT AS "NOT(SPLIT PERCENTAGE)=0" GOTO THE RECORDS TO SEQ_FILE(WITH 90%). IF MY SOURCE SEQ_FILE HAS 2 SAME RECORDS ,SPLITTING IS APPLI...
by pandu80
Tue Apr 12, 2005 11:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SEQFILE
Replies: 4
Views: 1301

SEQFILE

Hi I have sequential file with customerid,supplierid and Lookuphas file with customerid and profit percentage. SEQFILE cus_id Supp_id 100 001 Hsh_file cus_id Profit% 100 10 101 20 If the customerd is equal then based on the percentage i need to create one record with 10% and one with 90%. So my targ...