DSXchange

help please...
thanks..

Thanks Guys, i was testing with test button in routine.... As you adviced I added pxengine/bin to the $path... it throws the error APT_config_file not found,but there is entry for $APT_CONFIG_FILE in administator. i tried adding $APT_CONFIG_FILE in dsenv file it works fine... but one doubt in this ,...

friends,
i am trying to run orchadmin command in the server routine...
but it is not executing,instaed failing with error orchadmin not found
i have set the config file path, orchhome path in the administor(not in .dsenv)
please advice

thanks guys..

hi friends, we use invocation_id to run a job.so at the end of the day same job has run more than 10 times with different invocation_id .this creates several entries of same datastage jobs in director.... i want to delete the log entries created by the invocation _id.. does datastge have inbuilt rou...

Friend,
(Example for ur question

Input
name
add1
add2
add3
age


outputcolumn derivation
name name
add add1,add2,add3..
age age


hope this will help you

friends,
i am using oracle stage to load the records into oracle Db .while loading, few records got rejected due to some reason.currently we are getting sql error code from the reject link,but i need to collect the message(reason for rejection) in a file.
please advice

Guys,
plan to take datastage certification,request you provide the link to register for exam.
Thanks
Edwin

hope DSguru2B reply would solve your problem

sorry .

Can you post the error message?

Friends,
can any one suggest me?
i want to merge two files
whether i can use sort stage externally or leave the merge stage to take care of sorting before merging...
which will be better in performance ...?can u please explain the reson also?

Thank you

i am not using any function convet string to time stamp m just hard coding as ""

Friends, when i tried to default the timestamp filed with null value("") in in transformation i am getting the folllowing error APT_CombinedOperatorController,2: Conversion error calling conversion routine timestamp_from_ustring data may have been lost Ora_Lot_Attributes,0: Failure during ...

i guess that that Business objects has not been relaesed from the SAP side...
In SAP once the Object has been compiled and ready to use.. they have to release ..so have touch with SAP team..