DSXchange

hello, if my interpretation about your doubt is clear, i think you want to use a parameter, just like all other parameters used in JOB-PROPERTIES . If you want to use this job to be executed from Batch file. Then i think below could be a solution which is quite cumbersome. you have to use these codi...

hello, with this routine, once a Arg2 which is like key-value pair as A=1|B=2|C=3 or even like h=hello|j=jai|k=kamat. i think the lookup Arg2 is session specific, if you try to add more value to lookup to Arg2 after executing and re-run the routine, it does not work. if you close your session, i mea...

you can use

DSGetJobInfo(JobHandle,DSJ.JOBSTARTTIMESTAMP)

need little formating. (server job)

i agree with chulett their should be no problem.

below are the steps for reading .xls file. for example in my case i have a data like 12 hello 51 hello 13 hello 43 hello 15 hello 21 hello 58 hello 60 hello 34 hello 89 hello in two seperate columns of sheet. 1. Import the file structure from "sequential file Definitions". 2.you will get a...

looking at UIDCONTRACT COMMISSION_TYPE, combination of both seems to be unique, please provide more data for input and what exactly output you want.

hello with so much of post little confusion !!! i think you want your input data like sachinbankarparthkarkahnyusuf to be like sachi nbank arpar thkar kahny usuf i have used a routine for this conversion, but it shows a data in output file like "sachi nbank arpar thkar kahny usuf" so need ...

i have not used this but you can try using WRITEU or WRITEVU.

hello, just for testing i created an input file where i use a value of particular field which is more than the length described in database(oracle). in transformer i use a constraint "REJECTED". so the particular record which does not satisfy the precision or length is found in a sequentia...

i think routine was exported without source code option being checked, so the routine is exported just with object code, you can compile,test this routine but not able to view a code.

please could you provide more values where you are facing problem, just to analyze the data, may be something related to trunc or rounding of values, or may be something as suggested by ray.

you can use compare function and use its return value for your proper propagation.

hello i am new to datastage, but below process is followed by department. for batch file you may be using DSExecute.exe with parameter as job name. in this job, go to job-properties-->job-control. in job-control write your code which will use following routines like DSAttachJob DSRunJob DSGetLogSumm...

hello,
the stage variable declaration in stage properties,then definition and then constraints.

just like in any language.

declaration,definition and usage of the variable.

hello dear, i am little doubtful about your output data, if you could be little precise on output data, we can find some proper solution.