DSXchange

Yup.

And as someone else pointed out to me, some actual post counts are different on the home page when compared to the information in the profile. Mine and Kim's are two examples. Not that I'm overly concerned with the 'missing' (or overcounting) three posts, just thought it was... odd... and worth noti...

Easy. During the Import you have a choce of 'Import All' or 'Import Selected'. Take the selected option. It will still have to load them all into memory to show them to you, but then you can then select any number to actually import, including just your one.

All he meant was that you could set up multiple ODBC sources in the configuration files and then specify the correct one for each run via a job parameter used in the DSN field.

I think you'll find that you need the WHERE clause if you use a Dynamic Relational Stage, even if its connection protocol is set to Oracle. I had assumed that the OP required to invoke the sequence for each row processed through the job. No idea on the DRS, haven't had the pleasure yet. Does work a...

Thank you, Sir.

[settles back down into the darkness at the back of the class]

[raises hand from the back of the class]

What is the other reason, Sir?

You don't need the 'where' clause or the reference key expression to accomplish this. Use a select in the form of: SELECT seqname.NEXTVAL FROM DUAL as custom SQL in the OCI lookup stage and define one column to hold the value. Make sure the column is not marked as a key column. No need to provide a...

I concur with what Ogmios said about non-root installs. Take the time to hunt down and capture an SA so they can help you. Do a root install. There's no need to run any of the scripts you listed afterwards if you go that route - unless they are specific to AIX - and it will just work when you are do...

There are different ways to approach this and it depends on what you are comfortable with. DataStage has a Folder stage that can be used to bring a list of filenames in from a directory. Those filenames can then be passed to another job or routine that, one by one, processes them. One problem, thoug...

DSLink9? Sequential_File_8? You need to start renaming your default link and stage names to something more meaningful. The name of the sequential file to write to (or read from) defaults to the link name. Right now it seems like yours wants to read from a file called DSLink9 and the error means it d...

Luckily, it's in the proper format so a string sort will work just fine on that field.

Actually, it's http://developernet.ascential.com - Ascential Developer Net. Soon to be IBMWSDN.

If you are sure you really want to take this approach, you could (in a routine) call UtilityAbortToLog which would log a message of your choice and then abort the job. Do this conditionally based on the status coming in and pass the status back out of the routine.

I have sequential file with variable column lengths.I want to read this file.So i need to mention the column delimiter as Unix New Line Character. Umm... no. That would be the record delimiter. I would think the column delimiter would be a comma or tab or something of that ilk. BTW, you need to com...