DSXchange

It's not the Routine activity that's failing in the job sequence - it's the Job activity. Check that the job name is correctly spelled and cased.

Define the maximum number of columns. Use the "incomplete columns" rule, which you will find by scrolling the Columns grid to the right.

Of course dates can be compared! Who said they can't?

The "schedule" on a UNIX platform is your crontab file. There is no mechanism to include this in an export. At best you can script to display the contents of your crontab file into a text file and keep that with your export. How you would rebuild that schedule would be up to your own ingenuity (scri...

If you could post the format of the sqlldr log file, it would be a doddle. Not everyone has access to Oracle, d'you see?

Isn't that what I said (\\Computername defaults to local machine) in the second post in this thread?

You use the UV stage or the Hashed File stage. In a routine (still don't understand why you need a routine - data obfuscation can be done perfectly well with regular jobs) you open the hashed file with Open, you write records to it with Write, and you close it with Close. The Write statement must be...

Welcome aboard, raji. :D Do you mean the logistical details, such as where to find an examination center? This information is available on the IBM web site indirectly, then you have to find the local office of one of the testing companies. Search this forum to find out about the assessment and feedb...

State your requirement in English (not DataStage). Is it, for example, one of a specific set of names that you have to wait for? Do you have to wait for any of them, or just one of them? If the latter, what happens then? You may be able to use a Routine.

Why do you want to convert to Integer? CurrentDate() returns a Date, and presumably your input column also is of type Date. Have you tried the expression you posted? Obviously the values generated by the expressions X and Y must be of the correct data type for your output column.

Presumably, in Hawk, it's simply a call to the metadata delivery service?

Within routines. Only within routines.

Let me get this right - "they" want you to write a routine to reinvent what a supported stage type already does?

Use a UV stage. Edit the DDL so that it's key column is created with a DEFAULT clause. This will generate the sequence for you.

Try putting into the Table Names box and not checking the Normalized check box.