DSXchange

I do not know why you want to copy job property instead of saving the job as template as use template anywhere you like.
If you really want to do it, yo can expport both jobs as dsx file and open it in Ultraedit.
you can copy and paste just like word document then import back into datastage.

I have same problem, so I seldom use link collector.
when I have to use, I use hash file. or I write into several sequentail file and then cat then after jobs.

hi, I use MS-SQL Server but I need to do the conversion in Datastage not in Database. I tried using 'Fix' But it doesnt work :cry: Thanks! Naveen. if A is a number in a string format, in your derivation, put A/1. I am sure that will solve your poblem. forexsample, the data is 00050. after 00050/1 i...

Hi Sai, The source is like 'Date1,Center1,City1' 'Date2,Center2,City2' ... 'DateN,CenterN,CityN' I am splitting the row based on the delimiter "," and how do I concatenate all the rows into one column ! It is a SQL Query that returns the rows like this and I have no fixed number of record...

Sainath.Srinivasan wrote:You have not defined that parameter in your job.

one possbile reason is that you look up hash file before the file is crreated.

if the data is clean, i mean they are all valid date, the eastest way is to use sub string function. string[].
of course you can use iconv and oconv, but it will cost performance more.

i met the problem, just opy and paste all the stage into a new job

look up can solve this problem, i think,
a lookup will find what is match, if not find, return null. so you capture the null value, instead of not null value.

your hash file format is not right.
or
I met this problem beore. becasue I use composed key in hash file and one of the keys is null value. when you map the hash file to ODBC, the null value field will not be null value, it is something that datastage can not understand.

in transformer, after stage rountine, excute sh script,
rm file_path/file_name

Hi All, I havn't used routines earlier, Could you plz assist me how to include some value in Job status in a job activity and how to retrieve in another job activity. ray.wurlod wrote: Use a job sequence to run the jobs. In the job that generates the value, have it also place the value in that job'...

use cat command to concatenate the file then read. simple?

the datastage can not recognise the date foramt(dd/mm/yyyy)
use oconv and iconv to format the date to yyyy-mm-dd then you can load date. the delimeter symbol is not important.

I have ever used the sort stag and hash file, as said in previous one said, it wor fine if the data amount is not huge.
if the data is too large, sort using unix script then use hash file or aggrerator to get the last one

load the table into a hash file then read and write the same hash file by using load into cache and lock when update option. it will update the hash file then refresh the hash file which will will looked up. after the hash file, there is odbc stage. the problem is how you update when the table is a ...