DSXchange

No,I in the properties i have set it to the change code column.

we don't need it in the output rite?

Hi All, I am trying to use insert/update with change capture stage in DS parallel version 8. The change capture job is working fine and i got change codes with the data. While applying this change dataset to DB2 source table with change apply stage i am getting below error, Change_Apply_37: Error wh...

Hi aquilis,

Thanks for the reply.
my concern if we use transformer, possibilities of performance slowdown.

Hi, I have requirement where i have source table and a reference table for lookup (one/more tables). I need to lookup reference table and the rows which fails lookup and validation should go to reject table. eg: after specifying the lookup columns in lookup stage, there is a column Cal_dt in source ...

thanks. it worked

Hi,

Thanks for the reply.

In the o/p seq file i want null values for that column.

if i specify NullFileldvalue = '' will it work???

thanks,
Deepak

Hi, My requirement is to generate .txt files from a table. i am using a oracle, transformer and Seq file stage. we have few columns which are decimal and varchar and are nullable. while writing many of the records are dropped for handling the null values. please let me know how handle nulls?? Thanks...

Hi,

I am transfering the file from ETL Unix Server to another Application Server. can i give the permission to the transfered file as rwxrwx-r (i.e/ 755 or file should have write permission to owner as well as to the group which owner belongs?

Thanks,
Deepak

chulett wrote:More of an ftp problem than a DataStage one, it seems. Is it consistent? ...

Yes i am getting this message for every run

[quote="chulett"]The largest value it could be, meaning the length of the longest record type. ...[/qu Thanks Chulett, I got it now. But in log am getting like this: "FTP_Plug_in_4,0: Info: try.FTP_Plug_in_4: 'RECV' call failed, error number = [11] Info: try.FTP_Plug_in_4: unable to g...

My assumption was that it is already tab delimited, thus you could send it as a long string and it would preserve those delimiters. Is that not the case? If not, command line ftp won't h ... Thanks Chulett. Since the job is monthly run the file might have huge records what is the length we can spec...

Try reading (and transferring) it as one long varchar field. Either that or there's always command line ftp. ... Earlier i also thought of reading as long varchar, but the file should be a tab delimeted at the target server. so if i read it as long varchar as one field i cant format individual valu...

FTP it as one long string field and tell it not to add anything (like quotes) as it transfers the file. ... Thanks Chulett. I forgot to add few things earlier. The file which am doing FTP is concatenation of 3 files. Header1.txt, Header2.txt and DetailRec.txt and the appended final file name is SEC...

Hi All, I have tab delimited ASCII text file created by one of the job. The file has been created in ETL server and my requirement to move the file to a diiffrent server(application server). can i use the ftp stage? If i use FTP stage will it preserve the file integrity. i am asking this question si...

:? My example showed that. "MON" = upper-case three character month, "mon" = lower-case. Pick whichever you like. ... I got month as MON from dual. but when i have inserted this date into the table there am getting as 22-aug-2008. can i have this as 22-AUG-2008 Thanks, Deepak Th...