DSXchange

Whatever you provide it must match the date picture specified for Oracle.

What is the reason that you can not create the table? What error code appears in the error/warning in the job log? For example, do you have appropriate permission in the database to create tables? Did the DROP TABLE statement fail (which would cause a CREATE TABLE statement to fail)?

Job parameter names have to be legal variables names. The prompt text can be made more meaningful text, and in local language (for example Arabic or Korean). I advocate and counsel use of meaningful prompt text, and always supplying help text, for job parameters.

LOGTO within programs is fraught with danger. For example, once you arrive in the new account (this works OK), which VOC file do you have open - that of the new account or that of the account from which you departed?

There are products out there (like Partition Magic) that can help. They can also re-build your server with a larger C: drive.

The warning limit set for the job sequence is propagated to all controlled jobs. Therefore the short answer is "any single job". You can, of course, check the "log warnings in job sequence" compilation it increase the chance that the job sequence itself will get to the warnings limit.

I am working with datastage server jobs, I can't use merge stage in server since I have to mention different key name for the same column. Vinod This is not correct. The column names (when working with sequential files) are totally irrelevant. Adjust the metadata so that you do have a common key co...

What else is in the log for the job sequence? Particularly what message reports the attempt to run the second job?

What information is in the log for the second job itself?

Hi Cud anyone tell me wats wrong with the below stmt... I've used this stmt to concatenate a " to the rec if it contains QuoteChar. but the output returned is that every stmt is appended with a 1 at the end..... if(DSLink12.F1[1,9]= "QUOTECHAR") THEN DSLink12.F1 :'"' else DSLink12.F2.. thanx Anee I...

kris_r wrote:Any idea Guys?

Etiquette Note
This is an all volunteer site. Folks post as and when they can. If you want urgent answers sign up with your support provider for premium service and learn the true cost of "urgent". Don't push. Not everyone is in your time zone, and we do need our sleep.

$DSP.Close is a function exposed by a plug-in stage. That is, the problem is not with the Hashed File stage or the Transformer stage. Get your DBA to trace what's happening on these connections.

The only solutions are:

(1) five separate Lookup stages (only one reject link allowed)

(2) one Merge stage (one reject link per reference input)

(3) six-table Join and check for nulls (cumbersome!)

Since the error occurs at row zero, I would hazard the guess that your "first line is column names" property is set to False when it should be set to True. The raw data string also suggests that this is the case.

If it's a timestamp, it should be able to copy straight through (perhaps with an adjustment to the fractional seconds).

[Oconv() does not work with timestamps even in server edition.]

No. RCP handles missing metadata, not missing data. You need to specify a default value in the column metadata to handle the situation you described.