DSXchange

Hi,

How can assign 'rama's' to a variable in transformation derivation. I tried 'rams\'s' etc.,

Thanks

Thanks you all. Yes if we specify server related information we have use either of the below options with ALL parameters. -file <file> <domain> <DataStage server> or -domain <domain> -user <user> -password <password> -server <DataStage server> Thanks again for all your help.

Hi Ernie,

I used XML output stage. I didnt give any output link. I got stage options write to an output file option But in file path I can only select static file name.
Please let me know how give index or any dynamic value in the filename.

Hi Ray, I tried with -param (without -param also) but it still giving the same error :( . Please let me know is -param parameter is mandatory. How to resolve this error. :shock: runinfo=`dsjob -server $server -user $user -password $pswd -run -jobstatus -param dummy=d RMS_OFFSHR_RT test2 2>&1`

Hi, I am executing below unix script to run my job "test2" which is having only 2 parameters apt config file and dummy(which is not used in the job). Job is working fine from the designer. but script is not executing. Please correct me if I did any mistake in the script. dshome=`cat /.dsho...

Hi Ernie,

Messages may arrive at every 2 minutes interval are more.
Please let me know how can we allocate file names dynamically.

Thanks
mrvsr.

Hi All, Please help me in designing my jobs for below requirement. we have to read XML messages like below from message queue continuously <Root> <Header><table>emp</table><empcount>12</empcount></Header> <Detail><empno>111</empno><empno>222</empno>..........</Detail></Root>. Job should be started a...

I am using Oracle OCI stage input.
Under Input > Sql tab > userdefined ,generated ddl,usedefined ddl tabs got disabled . Please let me know how to enable this option. Which settings have to look into ?

Thanks Craig,

I am using oracle 9i. As I mentioned I have both source and target defined as CLOB. Using a CAST function and changing the target data type to Varchar2(4000) did the trick.

Hi, Please let me know how to transform CLOB data type fields from source to target. I have 2 CLOB fields in target, I assigned the data type to in DS as LONGVARCHAR 4000 to both of them but I am only able to view the data if I include first column. when I try to include only second column or both c...