DSXchange

It may depend on the plugin. The OCI stages do support multiple statements, this is pulled from the online help: If you specify multiple SQL statements, they are executed as one transaction. Do not use a trailing semicolon. Transactions are terminated by a double semi-colon ( ;; ). I know you can us...

Is your filename to check - Users.csv - a job parameter? The Execute Command stage doesn't parse them correctly. Yes, the log entry looks just peachy but the actual command executed includes the untranslated job parameter, which may be what's tripping you up. Me, I'd do this in a routine and use DSE...

Does anyone know if it is possible to use both the Oracle 8i and the Oracle 9i clients on the same server in one DataStage project? And how that would be done? Nope, can't be done. Sure, you can use the OCI8 plugin in one job and the OCI9 plugin in another, but they both would use the same (single)...

There's a long-standing bug with encrypted passwords and sequence jobs. For Oracle, you end up with a 'null password' error as noted in this older post.

I'm assuming you are running into the same issue.

Is there another way that is better? Unless the source can correct this and stop sending you an invalid file, I don't think you have much choice. Set the quote character to '000' to disable it and then remove the quotes from the data, either field-by-field in the job or by utilizing the Filter capa...

I have been importing some jobs of mine from 7.1 into 7.0 I really don't think DataStage supports imports to older versions, even across minors. While the process can upgrade jobs, I doubt it would attempt to 'downgrade' them and I doubt there would be any guarentee that the jobs would work correct...

That's certainly one way to do things. Question for you - what specific version of 7.x are you running? Environment Variables were a little 'broken' in the early releases, but fixed in later ones... I think you need at least 7.1 before they work fully. Before the fix, all jobs using them would need ...

Do you just want the 'dd' portion? Are you sure the format will always be as you've indicated? Then substring it out:

I understand that all of the jobs will be scheduled, my question is how? Do you have access to an enterprise scehduler? Will you be using 'dsjob' from the command line or cron via Director? Are you planning on using Sequencer jobs at all? Those kinds of things would drive different answers to your q...

Does anyone know how one goes about providing feedback on Ascentialworld? I've got some things I'd like to pass along of a 'constructive criticism' nature and I'm hoping to turn up the email address of someone at Ascential that would care or could pass it along to someone who does.

Thanks.

Kim, I think you are going to need to post over on ADN to get any play on this.

yaminids wrote:I am trying to separate date from a date record in 'ddyyyy' format.

Did you perhaps mean 'dddyyyy' format? If so, there is a 'Julian' conversion option for Iconv that would do that for you.

the method you implemented works fine you just need to debug it. Sorta. Yes, the methodology can be made to work, but you can't use expressions in parameter default values. You need some sort of Job Control wrapper that computes the data and then assigns the resultant value to the parameter. Or bui...

Since this thread has now been dragged waaay off-topic, why "erroneously referred to as Marvin"? I have a basement crammed full of Marvin the Martian collectables from Warner Brothers before the Studio Stores were shut down.

Welcome aboard! :D

I can't check right at this moment, but isn't there some sort of 'timeout' property in the stage somewhere for the telnet stuff that you can adjust?