DSXchange

Thanks Ray. It worked fine. I modified it a little bit to serve my purpose. Didn't know what "Element" in the code means. InputArg = "cd " : pFilePath :"; ls -1 " : trim(pFilePattern) Call DSExecute("UNIX", InputArg, Output, SystemReturnCode) If SystemReturnCo...

I wrote a routine to make it a comma delimited file and pass it as a parameter to the start loop stage. It worked fine. But if there are many files then the routine generates a new line in the output and the job fails. *FilePath(Arg1) directory where the file exists and pFilePattern(Arg2) is the pat...

Yeah. I did look at file pattern option, but it concatenates all the files of the pattern into one and tries to process it. I would like to process one file after the other.

Hello, Which would be the best approach to process multiple files of a same pattern in a folder one after the other so that the run time logs for each file can be captured separately. I tried to use the execute command activity to capture the head file and send it as a parameter to the Job activity ...

I am loading data into oracle via upsert and some records are being rejected into my reject file with the code -1403. What does "code -1403: update record not found" mean??? If the record already exists then i want to update it. The table is an empty table. Any help is appreciated. Arun.

I used select trim(column name) from table in a user-defined sql from my oracle enterprise stage and it did not work. Gave me this error: Lookup_12: Error when checking operator: Key field "column name" not found in input schema main_program: Could not check all operators because of previo...

Hi,

How can I trim the columns in a user defined sql via Oracle enterprise stage?? I tried using Trim(column_name) in my user-defined sql and it did not work.

Do I have to use a transformer to trim fields??

Thanks,
AR.

Hi, When i try to import column definitions from an oracle table using Orchestrate schema definitions it converts all the date type fields into timestamps. I have to load these columns into a numeric column in the target table. Question 1: How can I import date type column as date?? Does DS support ...

Hi all, We recently migrated to AIX from Sun OS and configuring QS on the new machines. I am getting this error when I try to run a Matching job in parallel extender mode. The matching job runs fine in file mode. I also have a standardization job which I am able to run in PX mode. ##E TOSH 000289 10...

Hi, I got this error when I tried to execute a standardization job in PX mode. It works fine in file mode. "Error exec: ##E TCOS 000001 15:04:09(008) <main_program> Licensing Error: Could not find a license Op Failed osh (255)" Any suggestions would be helpful, Thanks, Arun.

Thanks Ray.

Hi, I am getting this error "[b]ds_loadlibrary: error in dlopen[/b]"when I tried to extract data using the db2 api stage and write into a seq file. We are migrating to AIX from sun solaris and trying to setup DS on the new servers. These are some of the other errors from the same job: &quo...

If I execute the script from a routine activity, I have the same problem It works in dev and not in test. This the input argument I give to the routine activity --- '/appl/EIA/cimgate/email/XXX.ksh "$a" "$b" "$c"'---- I overwrite these parameters($a, $b,$c) during runti...

Ken, I clicked on the job in status view and it shows me the values I gave. But inside the Director logs it shows me the default values. If i run the exact same job in development environment and overwrite with fake values then it ends with a warning, saying that the parameters are wrong. If i run i...

Hi I have a simple shell script whick i execute using the execute stage. When i run the script i overwrite the parameters with values I want. When i export it to the testing environment I am not able to overwrite the parameters. It always takes the default parameter values, even if I try to overwrit...