thank's you all, i've tryed with column generator and it seems run well.
thank's very mutch to all!!!
Search found 19 matches
- Thu Dec 11, 2003 9:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: UNIQUE ID WITH COUNTER IN PX ...
- Replies: 9
- Views: 3850
- Tue Dec 09, 2003 11:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: UNIQUE ID WITH COUNTER IN PX ...
- Replies: 9
- Views: 3850
- Tue Dec 09, 2003 11:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: UNIQUE ID WITH COUNTER IN PX ...
- Replies: 9
- Views: 3850
- Tue Dec 09, 2003 10:01 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: UNIQUE ID WITH COUNTER IN PX ...
- Replies: 9
- Views: 3850
UNIQUE ID WITH COUNTER IN PX ...
hi all. i've searched in precedent forums how to create a unique number to insert in a field. i've a flat in input , after tranformer stage i insert rows in a table, and rejected rows in another table. in this second table, i 've added in db2 a column for a new id. Now, i cannot use the server funct...
- Tue Dec 02, 2003 5:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: FIELD FUNCTION
- Replies: 7
- Views: 3104
- Mon Dec 01, 2003 10:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: FIELD FUNCTION
- Replies: 7
- Views: 3104
hi 1st, i need to reject the rows if a field contain some special characters so now i'm using COUNT or INDEX to know if the string contain a specific char(if return of these functions is 0, i know that the string is right...) but so i have to process only one character at time ... if i have to contr...
- Mon Dec 01, 2003 9:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: FIELD FUNCTION
- Replies: 7
- Views: 3104
FIELD FUNCTION
HI ALL. i' ve still a problem with special characters. i cannot use some function with parallel xe and i'm looking for the best performance way to retrieve special char from a srting. someone knows if there is a function that retrieve more of one spec char from a srting???? ex: ("MARK&O AND...
- Thu Nov 20, 2003 9:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: HOW CAN I USE BUILDOPS IN PARALLEL???
- Replies: 2
- Views: 4441
HOW CAN I USE BUILDOPS IN PARALLEL???
HI ALL,
IN MY PRECEDENT TOPIC I ASK AS I CAN USE DS FUNCTION BUT TEEJ
TOLD ME THAT I HAVE TO USE THE BUILDOPS ... WHAT ARE AND HOW CAN I USE THEM ???
I 'VE WORKED WITH DATASTAGE SERVER AND I DON'T KNOW THEM...
THANK'S FOR HELP!
IN MY PRECEDENT TOPIC I ASK AS I CAN USE DS FUNCTION BUT TEEJ
TOLD ME THAT I HAVE TO USE THE BUILDOPS ... WHAT ARE AND HOW CAN I USE THEM ???
I 'VE WORKED WITH DATASTAGE SERVER AND I DON'T KNOW THEM...
THANK'S FOR HELP!
- Wed Nov 19, 2003 10:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SELFMADE ROUTINES WITH PARALLEL
- Replies: 3
- Views: 3326
SELFMADE ROUTINES WITH PARALLEL
HI ALL,
in the designer i have created a copy of a routine and rename it.
inside a transformer stage i search it but there isn't ...
in DS SERVER i know how to find it, but in PARALLEL ????
can anybody help me ???
in the designer i have created a copy of a routine and rename it.
inside a transformer stage i search it but there isn't ...
in DS SERVER i know how to find it, but in PARALLEL ????
can anybody help me ???
- Mon Nov 17, 2003 11:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error log with column i need help too...
- Replies: 3
- Views: 3449
thank's for your helps. abaut the teejs post i don't understand if i have attach the log/error stage to the transformer or or on the db2 stage: and in log/error stage constraints i have to write : If (col1...Then 'col1' else if col2... then 'col2') ? another little question... how can assign the nam...
- Mon Nov 17, 2003 8:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error log with column i need help too...
- Replies: 3
- Views: 3449
error log with column i need help too...
HI, thans all for your help. I have problems too. my job is as follow : an input seq file ----> trasformer------> db2 stage !____> rejectedrows stage. i need to insert in a table (or in a file) a log message for each record rejected. the message have to contain the name of the column that raise the ...
- Mon Nov 17, 2003 7:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: TYPE MISMATCH ERROR OPENING DIRECTOR...
- Replies: 4
- Views: 4652
- Mon Nov 17, 2003 4:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: TYPE MISMATCH ERROR OPENING DIRECTOR...
- Replies: 4
- Views: 4652
- Mon Nov 17, 2003 4:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: TYPE MISMATCH ERROR OPENING DIRECTOR...
- Replies: 4
- Views: 4652
TYPE MISMATCH ERROR OPENING DIRECTOR...
HI ALL.
I TRY TO OPEN DS DIRECTOR, BUT I RETRIVE THIS MESSAGE :
RUN-TIME ERROR '13':
TYPE MISMATCH
I NORMALLY ENTER IN DESIGNER, MANAGER AND ADMIN BUT NOTHING FOR DIRECTOR.
SOMEONE KNOWS THIS PROBLEM???
I TRY TO OPEN DS DIRECTOR, BUT I RETRIVE THIS MESSAGE :
RUN-TIME ERROR '13':
TYPE MISMATCH
I NORMALLY ENTER IN DESIGNER, MANAGER AND ADMIN BUT NOTHING FOR DIRECTOR.
SOMEONE KNOWS THIS PROBLEM???
- Fri Nov 14, 2003 8:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: LOG WITH THE NAME OF THE COLUMN ...
- Replies: 3
- Views: 3522
LOG WITH THE NAME OF THE COLUMN ...
HI,
thans all for your help.
I have a job as follow :
an input seq file ----> trasformer------> db2 stage.
i need to insert in a table a log message for each record rejected.
the message have to contain the name of the column that raise the error.
how can i do????
thanks to all.
thans all for your help.
I have a job as follow :
an input seq file ----> trasformer------> db2 stage.
i need to insert in a table a log message for each record rejected.
the message have to contain the name of the column that raise the error.
how can i do????
thanks to all.