DSXchange

when i save the sql in notepad the size is 33 kB. Thanks Arnd, I just have the column names,not in the form of schema.table.column. Is there any other way than changing the column names . when we insert values into columns as ORCHESTRATE.<column value> in the Insert statement that is taking some spa...

Hi, we are trying to load a cobol file into a oracle table (with 600 columns in table).we just Insert rows into the table. We use the write Method Upsert and then select the Upsert mode as 'User defined update only',and write the Insert statement in there.But since table has many columns the whole i...

The environment variable APT_STRING_PADCHAR has been set to default .
what should i change it o overcome this problem.

Thanks

I am not using that Environment variable in my job parameter though,Do you think still that might be the problem.

Thanks

vkhandel,

The trim function which you have posted worked.
But i was wondering why isn't the normal Trim not working .

Thanks!

I already have a transformer between Db2 stage and a CDC stage,where in i am trimming the varchar fields.
But still there is problem.

Thanks

Can some one give their expert views on this issue.

Thanks

Peek1 Col1:X Col2:1 Col3:. Col4:ABC Col5:Address1 Col6: Col7: Col8: Col9: 0000000.00 Col10: 00000000. Peek2 Col1:X Col2:1 Col3:. Col4:ABC Col5:Address1 Col6: Col7: Col8: Col9: 0000000.00 Col10: 00000000. Col3 is of type Char(1) and the value in it is '.' The Col6 ,Col7 and Col8 are empty strings('')...

Can some one shed some light on this.

Thanks

Hi, I have requirement where i have to compare a dataset data with data in DB2 table . I am using a CDC stage to do this,I have the following settings Change Mode:Explicit Keys,All Values DropOutput for copy=True DropOutput for Delete=False DropOutput for Edit=False DropOutput for Insert=False I hav...

I am doing the below in the stage variable before doing this comparision STR('0',6-Len(Trim(col1))) :Trim(col1) and then i have to implement the logic for Date, And the stage variable is of type Varchar. Now how my comparision should be as below If Right(svDt1,2) >'10' then '19':svDt1[5,2]:svDt1[3,2...

I have a requirement where in i have to convert mmddyy date format into YYYYMMDD for example the date would be 070307 the output should be 20070307, if the date is 012975 the output should be 19750129. I have to compare the last 2 charaters from input(yy) if it is greater than 10 it has to be append...

Yes,that was the problem with a ".".

Thanks

when i enetered SH -c "tnsping servername1" in administrator,i got the below output Used Parameter files /xx/orasoft/product/9.2.0/network/admin/sqlnet.ora. USED HOSTNAME adapter to resolve the alias Attemping to contact (DESCRIPTION=(CONNECT_DATA=(SID=*) (SERVICE_NAME=servername1.)) (ADDR...

I have checked the job log and the parameters are the same values(user_id,passowrd,Remote server) which i am using to connect through Oracle Sql Plus.

And i am using Oracle Enterprise stage to connect to Oracle.
I am passing values into Userid,Password and Remote Server.