DSXchange

Hi, I am passing an environment variable to a job and want to pass the value to one of the fields in the oracle stage. I am using Oracle load option, so i am passing the value in the transformer before that. It is giving me compile error. can anyone help Output from transformer compilation follows: ...

I modified the job to explicitly include a space. i.e

if the width is 5 char
If isnull(xxx) then space(5) Else xxx:Str(' ',5-Len(xxx)).

But i expected this spaces to be padded in the char field since i included the APT_PADCHAR environment variable.

If you have any thoughts please let me know.

The issue got resolved. I had given the name of the column in the transformer as RCD_REF_NO.Date and RCD_REF_NO.base which didnt show error in the designer.
I changed it to RCD_REF_NO_Date and RCD_REF_NO_base. Now it is working fine.

Hi, While i am compiling i am getting the following error. Could someone help. ##I TOSH 000002 23:50:52(001) <main_program> orchgeneral: loaded ##I TOSH 000002 23:50:52(002) <main_program> orchsort: loaded ##I TOSH 000002 23:50:52(003) <main_program> orchstats: loaded ##I TFSC 000001 23:50:52(006) <...

Actually i could see the file while open it with textpad with all the contents..i think the null is creating the problem.. I have char as the target field types as it is a fixed width..I am using APT_PADCHAR and set it to ox20..but i think the padding is not happening properly..what can i do to pad ...

Hi I am reading 4 datasets, combining them through funnel and doing some datamanipulations using a transformer and then output the values in the output file(fixed width file) My problem is that From the input file the number of records are coming. But except the first column value others are not com...

Hi, We have a job in server where we are using the reference and the output as the same file. For example. We have the following records in the file key1,rectype,update 1111,AA,1 1111,BB,2 1112,BB,3 1113,AA,3 In this file Record type(rectype) AA is an insert record and BB is an update record. Once w...

I have a ds job where the design is like this input stages(doing some join etc here)-->transformer-->aggregator --seq file i am counting the number of records based on a key in aggregator stage and storing the value in a sequential file. here since the number of records are more, it is storing it as...

hi, my update clause had two keys(in the where clause as well as keys indicated in the metadata) but the table had only one key. I think this has caused the updated to fail. I am yet to do the full testing, but since i had to complete the task in a hurry, i deleted the records which had to be insert...

Hi, I have a server job and have the target table as an oracle stage. I am doing inset/update (insert new rows or upsert existing rows). But still i am getting this oracle error ORA-00001: unique constraint (CVID_UAT.PK_CV_WE_PRE_INSPECT) violated Ideally we should not get this in an upsert mode, is...

thanks Ray and dwh..that cleared my doubt..

Hi

I have a question in joining the records in a sequential file and a table.

Can we directly join/lookup a sequential file and a table (using transformer) or should we have an hash file in between..i have seen this in many jobs that a hashed file is used before joining..but is that mandatory?

Than you so much LenGreenwood..it worked. i just pressed the ESC key and tried opening the oci stage again and it opened without any issues. i never had to change anything else..i have been having this issue for a while and trying to catch hold of my service provider as it is a long process.. thanks...

Hi I am not able to open the oci stage in server jobs(in parallel jobs it is fine)..so wierd..when i double click on that stage, it just highlights that stage and nothings happens after that. then i am not able to use the designer window and then just hangs. i am having this problem only for my wind...

Hi i have a very simple job seq file-->transformer-->OCI i am doing an update in the OCI stage based on a key valye. In transformer, some simple expressions. it is taking the value from seq file and passed the transformer, but it is not updating the OCI stage. i am trying to update just 5000 records...