DSXchange

I need to copy hash files from one environment to another. I ftp'd the files: h_hashname & its directory, but when I tried to view data, it wouldn't open.

Thanks much for your help..

from archive/prev posting, I saw how to programmatically set the auto-purge property on each jobs.

Would the script work in read-only env?
In our prod env, the DS projects are protected & all objects are read-only.

We have datastage log auto-purge set at project level from dsadmin. It is set to purge in 5 days.. But when I look at log it contains everything from day-1, so I suspect this auto-purge does not work..
If anyone could give me some pointer where to look to fix this..

My job is very simple.. TXT infile --> transform --> txtOutfile txtOutfile has some derived columns, including: LineNumber = @INROWNUM Constraint @INROWNUM<>1 (as this line contains file header info) So far, This happens 3x since 1/11/05 on my system (normally, this job runs 50-60 in a day) And it's...

I ran into several occurence where @INROWNUM yields duplicate numbers -- I was wondering if this is known issue
& how does this happen ?? -- thanks, HandyT

Where can I find out on the internal DS repository.

This is what I'd like to do:
Create report based on VERSION (DS version control)
-report each jobs that exists in different environment & report them side-by-side: their version#, date checked-in , 1line of comments.

hi KDuke, I downloaded etlstat & imported into DS but now I cannot delete them.. ? This solution does not work for me, because we have very limited access to DB, therefore I'm still searching for solutions based on hash or files only (anything that's only limited to ds, w/o touching DB)' Thanks ...

I tried this on v7.5
sometimes it works, but most of the time, JobGetLog returns (-13)
what does this mean ? I saw that the job in question finished normally & I can see the logs in director

Have u tried this: 1. export existing job to dsx file 2. change the setting & export to different dsx file compare two files & see if you can isolate the changes.. you can then try to export the whole project to dsx & make mass-changes Replace-all using text editors I tried this before b...

if I have single column source that have 0,1,..N rows -- how can I transform into single line? ie:

source
AAA
BBB
CCC

output: AAA BBB CCC

looking at your example, you want to: 1. read source fields: A B C D E 2. write to A C D E A B C D E I'd simply read the file twice (2 output links) --> hash (to enable multiple write at the same time) Hash1 text --> A C D E --> sort --> text-out --> A B C D E

This is the first time I see this.. what may have caused this ?
Abnormal termination of stage Jobname..stgname detected

I have 2 links from transformer that writes to hash.

can I guarantee that link1 is always executed first before link2 ?

I want to use link1 to clear hash first before writing.

but this brings to my original posting.. I have multiple jobs that are queueing to run one particular job. It already checks for DSJS.RUNNING. Looking at the log, here's what happened: 10 jobs are queueing to run JobX at one stage, at the same exact second, this checking triggers multiple jobs to tr...

Have you tried:

iDate = IConv(fieldName, "D-YMD")

iDate is now integer & you can easily Max(iDate),

But you have to: OConv(iDate, "D-YMD")
to display this back as proper date