DSXchange

thank's you all, i've tryed with column generator and it seems run well.
thank's very mutch to all!!!

excuse me but i don't understand that schema ...
i'm trying to set the property in the column generator stage ...

i'm trying to use the column generator but i don't know well how to set the properties to obtain a count with a unique number...
i'm trying as follow :

FLAT --> COL GENERATOR(in which i add the column) --> transform --> destination flat.

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...

THANKS FOR HELP, NOW I TRY TO USE THE BUILOP (PRAY FOR ME ....)...

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...

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...

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!

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 ???

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...

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 ...

THANKS, I'VE RESOLVED UNINSTALLING DS AND CLEANING THE REGISTRY FILES.

SORRY I FORGET, I HAVE REINSTALL DS CLIENT ON MY MACHINE
BAT I RETRIEVE THE SAME PROBLEM, THEN I'M ENTER IN DATASTAGE
WITH MY USR\PWD FROM ANOTHER PC AN I GO INSIDE....
I DON'T UNDERSTAND ...

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???

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.