DSXchange

I had this problem, the solution (not very good though) was to change the data types accordingly as 7.5.1 is not very liberal with data types.
Even I would like to know a better solution.

Thanks in advance.
Abhi.

Can you post the exact error that you are getting?

I vote for a general forum and the idea of sin bin is awesome. The people who find it hard to browse should get accustomed to it.

Thanks,
Sai.

If you are looking up for look up stage then please read the documentation. As a starter "The most common use for a lookup is to map short codes in the input data set onto expanded information from a lookup table which is then joined to the incoming data and output. " Also I see ure using ...

it is compatible with 10g.

Chandra,
Please search this site for all your answers. All ur interview questions have been answered before

3 rd interview question repeated? :D

Use date as Jobparameter.

I believe u can give the filename u want to extratct and going further looking at ur files u can use processing date as a job parameter and pass it in the file name.

Craig,
Thanks, telnet after seems to be a better option.

I believe if you have the right access u can write a script from ur unix box to ftp into the remote server and delete command will delete the rquired file, I am using it. Please correct me if I am wrong.

Thanks,
Abhi

What srimitta says is a good answer but also use trim befor u use a substring, instead i would use iconv and oconv.

srimitta,
Write a unix script to delete the file and execute it as an after job routine(ExecSH).

Thanks,
Abhi.

it is because its causing a deadlock, try to load the data into a hashed/seq file then update in a different job.

Thanks,
Abhi.

It can be even due to a deadlock.