DSXchange

I haven't tried this in DataStage but in many Windows applications you can use Ctrl-Tab to insert a tab where a regular Tab would move you to the next field. Once you upgrade to 7.5 you will be able to use any expression in a Job Activity in a job sequence and therefore will be able to use Char(9) t...

FYI, in my time zone your posts are timed at 3:30am, 4:15am and 6:45am. Do be patient; this is an all-volunteer site, and no-one provides 24x7 coverage. If you want urgent responses, sign up for premium support with your support provider. I am interested in what support has to say; I have always pla...

Maps onto renice on UNIX and a system function on Windows. Ordinary users only get CHAP DOWN, as noted. Just like PRIMOS!

A quick "if .. then .. else", then?

I think that you might best solve your issue by using a before and an after job subroutine. The before-job subroutine can use the OPENSEQ, WRITESEQ and CLOSE commands to write one or more header record(s) to the file while truncating it. The job itself writes 0 or {n} data records and then the afte...

Indeed Arnd's suggestion is the only sensible one, because only the job itself exists once. If you tried to create a header/trailer in a section leader or player process, you'd get one header per partition. However, you don't need OpenSeq and its companions. It may be enough to invoke an operating s...

Can't readily be done in a parallel job if you want to use a Sequential File stage to read columns based on a schema; the record delimiter character and final delimiter character can not be substituted with job parameters in this stage. Looks like you're trying to rewrite a server job in the paralle...

Stop overloading the hardware! Are your developers still "testing" with 30 million row runs? What other strategies do you have available for reducing total demand for server resources, such as scheduling things at different times? Has anyone scrutinised your ETL jobs to check that they're not perfor...

Try this (it has a LOCKED clause on the READU statement and an ELSE clause on the OPENPATH statement) and let us know how it tests. Don't forget to double click on the result cell so you can see what is logged. FileDir = "E:\ETL" FileName = "weightA0.txt" Ans = @NULL ; * initiali...

A job sequence is a specific instance of a server job.

What else do you need to say?

Welcome aboard! :D The bad news (for you) is that there is no error. "No match found" is the result of a query against the DB2 system tables; that you received that message indicates that connectivity is OK - otherwise a different error would have appeared. "No match found" means either that you hav...

Do you have NLS enabled and, if so, what client character map are you using? It seems odd that "Hello" is being converted accurately but "!" is not. Are you sure it's really "!"? (Check with a hex editor both in the EBCDIC source and the ASCII target.) Could be a strange problem with the data browse...

Make the point to management that upgrading to 7.5.1 costs no money (assuming you have maintenance/support), and delivers quite a few technical benefits.

They're not all in the Parallel Job Developer's Guide - open the Administrator client, select your project, click Properties, then click Environment...

You should find them in that list of environment variables. I was using 7.5.1A last week, and they're definitely there.

That chapter is repeated in the Parallel Job Developer's Guide which shows that the same command line interface is used for either kind of job. A job sequence is a special case of a server job, so these too can be managed through dsjob command. Interestingly, perhaps, dsjob began life as nothing mor...