DSXchange

It is defined in your uvconfig file and the default is 1930 (which is pretty standard): # CENTURYPIVOT - This sets the Century Pivot Year. # This value determines how 1 and 2 digit years are # interpreted by ICONV. A value of 1930 means that # 30 through 99 are interpreted as the 1900s, and 00 # thr...

Tony, there's a batch file that's posted at ADN that will back up all projects on a server. I'm using it and it is working great for me. In combination with command line WinZip, I can keep all of the exports from each night zipped up and taking up much less space than they would otherwise. It's call...

There's something else going on. Even if you are only licensed for one cpu it will allow you to install on a system with more. The downside is, each time every job runs, a warning will be placed in the log that you have exceeded your license count. What was the exact error? Do you have a current exp...

You are, it's just that it can be a little painful to setup correctly. You are much better off using Fully or Column generated sql unless you absolutely need something custom.

Excellent... forgot about that being here.

Sure, it's allowed. Are you using custom sql?

Orieos wrote:3. There is no 3....it's done :D

Excellent... there is no 3.

Thanks for the clarification, and glad it got worked out.

Ok. Read the online help for the Filter option. There's no need to use a named pipe for this, unless you prefer to take that route.

Simply putting the appropriate command in the Filter box (without the redirection as it leverages standard out) gets you what you need.

a) I'd be very careful if you take that route. You wouldn't want to change every occurance of 23 - only the entries associated with your hash file.

b) Out of curiousity, why do you feel you 'need' to do this? What kind of a problem is this causing?

c) Welcome aboard!

No. The use of the Filter requires no intermediate files. Neither does the other options I outlined.

Sure! That option is included in the 7.5 version. You can also find a routine that will do that for you for earlier versions uploaded into the File Library at ADN. It's called JobReport.dsx, I believe.

You could still play the 'First line is column names' game. In addition to that, check off the 'Ignore row truncation warnings'... either that or slide the 'Columns' definition tab to the right and set the entries that control missing columns appropriately. Or as noted in previous posts, use UNIX co...

You would need to write a routine that takes those settings and applies them to the exisiting jobs. Needless to say, that would require knowledge of the underlying Universe/DataStage Engine metadata and some decent coding skills. Haven't checked in awhile, perhaps some kind soul has uploaded one ove...

That's just... evil, Ray!

Define what 'transfer' means in this context and how exactly it failed.