DSXchange

Lots of folks did. Did you search the forum?

Now send dollars for a license to Data Direct. Your 30 day grace period has expired. The drivers supplied with DataStage are licensed only for use with DataStage ODBC stage.

Is it really Avenue, or is it Apt (Apartment)? That it is followed by a 1 (which you're putting in UV1) suggests the latter. Perhaps this particular A (in this particular pattern) needs to go into UT1 in the xxADDR rule set)? You need to determine that before you can accurately address the conversion.

Thank you for posting the solution. We probably would have got there, but it's good that it's solved more quickly. Can you please mark the thread as Resolved?

Do you have QualityStage licensed?

1 (i) OK provided your string is large enough
1 (ii) No provided your string is large enough
1 (iii) Yes
2 BigInt is 64-bit integer. 2^64 is 18,446,744,073,709,551,616 - that is, 20 digits.
The largest uint64 is 18,446,744,073,709,551,615; the smallest int64 is -18,446,744,073,709,551,616

Run Oracle on bigger hardware - mainframe perhaps.

Prove it. Post the record schema associated with the CFF stage. You can find this in the generated OSH in the job properties dialog.

Add some form of change detection/comparison between source and target. Use this to eliminate insertion of unchanged records.

Disable operator combination to isolate the stage that is generating the error.
Try using casing as per the manual for the function names, for example NullToEmpty().

Curious. They usually use nn for minutes (rather than mi), and you really would need matching quotes around your format string. But if you say it works, who am I to disbelieve you?

Read the warning again. You are performing an export (= writing in human-readable format). There are nulls in the data. You have not provided any property (for example Null Field Value) to tell DataStage how to represent NULL in the target. If the sequential file is fixed width, the Null Field Value...

Welcome aboard.

Procedural Note
We do not do urgent here. This is an all-volunteer site. People post as and when they can. If you want urgent help, sign up with your support provider for premium service, and learn how much "urgent" costs.

81002 means "the connection is broken".

Status view is the opening view of Director. The final event in the job sequence log may say "completed successfully", but in status view you may see "Finished (see log)". That is a clue that there is at least one warning or error message logged. You can detect the job sequence's status with DSGetJo...

Welcome aboard.

There is no default password.

You create the user as a Windows user, and allocate the password there. If you are a member of the Administrators group you can reset the password. If you are not you can't, and have to grovel to someone who is.

Look at the date conversion functions either in the Modify stage chapter or for the Transformer stage in Appendix A in the Parallel Job Developer's Guide - there are functions for extracting date components.