DSXchange

that helped a lot. it worked. thank you very much

i have a file that has product id and email id, what i need to do is concatenate all prod ids that have the same email id, so that i send the email only once. I wrote a basic program to do this. this would read the file and concatenate prod ids that have similar email id. this data would be writeen ...

it worked with this if (isNull(col)) setnull() else StringToDecimal(col)

We have a column PROD_KEY which is defined as NUMBER in the table, its allowed to have NULL in it. when we receive data in a file, its received as VarChar, when we try to insert into table, it gives the following error, PendingSeqFile,0: Field "PROD_KEY" has import error and no default val...

all the stages in Datastage Enterprise ediion 7.5.2 cant capture 'unique key constraints or foreign key constraints' even though you see the error in the log. i tried with server DRS , oracle, odbc stages, and also with parallel oracle enterprise, DRS and odbc stages. none of it worked. i did this a...

oracle enterprise stage doesnt have insert only uption. in the upsert mode all it has update and insert or update only

as soon as I set the option to true and come out of it my stage icon has yellow symbol indicating error. I opened transformer and there is no column added to the reject link or the valid link. i dont know if i am doing anything wrong here

i see an option to 'output reject records'. i set it to true. but i dont see an option to specify the reject link anywhere. the other thing i want to do is only insert but not allow updates, i dont see insert option only

all it has is OTHERWISE. it doesnt have DBMSCODE or REJECTEDCODE

i am trying to catch rejected records while inserting records into oracle database. tried with server job, even though log has the error message, none of the variables like REJECTEDCODE or DBMSCODE had values in it. it had values when there is an issue with the column values. what i want to catch is...

I need to update a timestamp filed when we update a record, ad we use oracle 9i. in th transformer there is TimeDate() function whic is in this format 'HH24:MI:SS DD MON YYYY' and when the sql is genarated its in this format 'YYYY-MM-DD hh24:mi:ss'. how do i convert the time stamp in transformer int...

i really dont know whether to insert or update unless i check the database, since datastage does allow 2 sqls we did that.

well i was initially using oracle stage but its having issues when we use 2 sql's 1 upadte and 1 insert in user defined sql, the same sql's work fine as expected when we use DRS stage, but oracle stage giving an error all the time.

thats exactly I am doing, I am checkig that condition on a reject link to see if VALID_LINK record got rejected. My database is oralce, and i am using DRS stage to insert into oracle.

i am checking for VALID_LINK.REJECTED