DSXchange

There isn't any other option. While technically the FTP stage says it can handle binary data, I wouldn't want to try and make it work... and I think you are out of luck in any case because the files are compressed.

Stick with your scripts and command line ftp.

If you try to leave it blank, it will explain what you need to do if you want no quote characters - use "000" (three zeroes).

Might help to know what you've tried... or what problems you had. How about a batch file that copies the source file to your archive location and adds the date tag at the same time? Using it in a Before Job subroutine call to ExecSH should be fairly straight-forward and could even leverage Job Param...

No problem.

Didn't mean to sound... harsh or anything. Just trying to (quickly) help people in-between train wrecks here at work.

No, it doesn't.

You've got the default filter turned on which only shows the most recent 100 entries. Try turning that off - Control-T or "View/Filter Entries".

Can I run two director sessions in parallel? Sure. can I set up shortcuts so that I can start either or both sessions without having to do a lot of typing? Disclaimer: This seems to work with 7.x but I don't know about 6.x Try adding the following parameters to the end of the Target string that lau...

Are 57 DB2 Stages too many for a single job? In a word - yes. Or more precisely - YES! I can't imagine you actually need all 57 of the DB2 stages. Unless they work totally differently than most others, why don't you consolidate them down to the minimum needed to support your processing streams? For...

The issue I am foreseeing is that a varcha2(50) column is becoming varchar(19). Would thsi truncate the data when i run the job? Yes, and generate warnings to boot. You would be better off using the OCI stage to import Oracle table metadata. It is under "Plug-in Meta Data Definitions". If you can't...

I've been looking into this as I'd never heard of a "Command Stage" before this. From what I can tell, it was only released on Windows servers. My HPUX version installed the .pdf documentation for it but the stage itself (or any installable package) is nowhere to be found. Hopefully someone running ...

In addition to what Ray said: Version Control uses dedicated Projects to store versions of jobs and to control promotion of these versions between your 'regular' projects. New to the 7.x version is the ability to easily support multiple VERSION projects, typically in support of different Subject Are...

What kind (brand) of database server? What version? Sorry, forgot to mention that bit... Oracle 9i Release 2. This data comes to me via CDC and I've yet to see anything (data-wise) in this table since the DDL changes that turned the field from a CLOB to this. It's... interesting... to try to get in...

You may want to try reinstalling the Client, if you haven't tried that already.

One of the new features in version 7.1 (not 7.0.1) of DataStage is some sort of automatic Checkpoint / Restart capability they have added to Sequence jobs. From what I understand (I haven't seen it yet) this would help get a series of jobs restarted from the correct job... getting the restarting job...

I'm just curious if anyone out there has run into this data type yet and can give me some insight on how to handle it in DataStage. It just showed up in the latest round of model changes being made in our source and it's a new one on me. There is no data in the table with this field as of yet, so I'...

Do you know of Director needs any special permission on the atjobs directory? Don't think so. You need to have been granted permission to submit 'at' jobs, much like for cron with its 'cron allow' concept. If you didn't have the permissions you needed, you wouldn't be able to schedule the job, let ...