DSXchange

Sure... more like this is how I do it: if <condition> then <expression1> <expression2> else <expression3> <expression4> end It's end else if <condition> then <expression1> <expression2> end else <expression3> <expression4> end [/quote]

It's a quirky thing, but yes a column in a multi-column key can be null. The "nullable" metadata doesn't matter. If you don't want these rows, you must put a constraint in to check for these. If a hash file only has one column as a key, it cannot be null. The rationale is that a multi-column key is ...

Google cron

Use replace option and use replacement value of something like "XXXXYYYYYZZZ" or something very noticeable and unlikely to appear in the missing column. Then, put a constraint on the following transformer to place the rows that have that column value in your reject file.

You have before and after SQL statements at your disposal, stored procedure based loading, as well as user-defined SQL. Pick your preference.

The length check only works if your columns have fixed widths and the missing column is actually NULL or blank. If the result of the CFF conversion is fixed width file, you may consider just reading that fixed width file as a single column, that way you only have a single column to check for length ...

You are correct, why do you think it's not working?

Look at any date columns and make sure the to_date statement is used on the SQL to insert the data.

Why are you using the ODBC stage and not the Oracle stage?

You probably had a previous run of the job fail leaving a stage thread still active. When you started the job again, that thread interfered with the execution of the job. It probably didn't allow the new thread for that stage to start, and so your job picked up the old thread as its own. You might w...

You can do anything. There are documented APIs to lock, set, and run jobs according to the methods you want. Do you want to read a file, get a list of jobnames to run, run those jobs, send emails letting people know jobs are done, compress and cleanup your work area? All it takes is planning what yo...

Add the filename as a job parameter, for example. FRED. At runtime, supply FRED a value using the smart job control you are working on. In the Sequential stage under the filename, use FRED like this: /path/path/path/#FRED#.dat or you can have the path already in the parameter value so just: #FRED#.d...

I'm still quite new to datastage, but I don't believe this can be done in a job sequencer unless you make a job for each source file (can be tedious). Ohayo gozaimasu. The Sequencers graphical metaphor basically requires an icon per job controlled. This works well for just a few jobs in a jobstream...

No, you cannot FTP a folder using the FTP stage. If you remember, we have spoken at length that the FTP stage is a remote file reader, not a file mover. Recursely transfering files and paths involves creating directories, changing directories, moving files by reading them involves varying file forma...

Go into DataStage Director. From the menu, do Tools --> Batch ---> New. This opens a dialog box that allow you to create a "Batch" type job. From the Add Job pull down box, experiment and choose a job. You will see job control logic appear in your properties box. Press the Close button and the job w...

Only if you used a job parameter as the filename, then the job parameter is also available in the transformer. Otherwise, unless you are willing to use an reverse-engineered method for retrieving job design information, no.