DSXchange

You can cheat here. Rename the hashed file on the "read" link temporarily to something that already exists (VOCLIB is a good choice). Validate or run the job to create the hashed file you require. Then reset the proper hashed file name on the "read" link.

Didn't say that. But if you remove a category there is a containment relationship, and you will need to remove the contents of that category. That means not just DS_JOBOBJECTS but also all the run-time tables RT_* for the jobs in question!

That nothing has changed in the job does not mean that nothing has changed on the system. For example it will be faster to insert 50 million rows into an empty table than into a table that already has very many rows. Newly added indexes, triggers and constraints will also slow load performance. Quer...

All of the horizontal combination stage types (Lookup, Join, Merge and Funnel) can use Sequential File stages to feed their inputs. Obviously there must be some matched-metadata requirements fulfilled in each case. The cat option suggested by others is very efficient given that, in all cases, sequen...

Yes, Char fields are padded. The default pad character is set with an environment variable (APT_DEFAULT_STRING_PADCHAR if I remember correctly), but can be overridden down to the individual column level. Right click on the column in the Columns grid to open the editor and find the pad character prop...

Danger!! Danger!!

It's not only DS_JOBS that you need to hack. Therein lies your dilemma.

Don't attempt it.

So, basically, the requirement is to sort by address and group by (a newly generated) serial number? Sort the addresses with a Sort stage, then use a Transformer stage to detect changes and generate the serial number, incrementing when the value changes. Run in sequential mode or partition by hash o...

Null Field Length property is for use with variable-length strings. You do not have any of these in a fixed-width file. Use Null Field Value property instead (they are mutually exclusive), and make sure that the value is of the correct length.

Nothing gets "detected" automatically. You have to have imported the "table definition" and gotten format and field definitions correct at that time. You then load this into the job and check that everything is still right (for example "first line is column definitions" does not load because it's no...

Do you have a rejects-handling output link from the Oracle Enterprise stage?

SERP also, in case you need Canadian addresses verified.

That just didn't do it. This function does: create or replace Function Get_Hdate(F_Date in Date) Return Varchar2 Is V_date Varchar2(30); Begin Select To_char(F_Date, 'DD/MM/YYYY', 'nls_calendar = '''||'Arabic Hijrah''') Into V_date From Dual ; Return V_date; End Get_Hdate;

This is usually a problem with your shared library search path, which should be set in the dsenv as an environment variable called LD_LIBRARY_PATH. It must be able to find the libraries in the branded_odbc/lib directory. Also, make sure that 32-bit database client libraries precede any 64-bit databa...

Or simply ask to read its contents, which will answer both your questions!

Note for users of Windows-based servers: the .dshome file is not used on these machines; instead the location of the DataStage install directory is unsurprisingly a Registry entry.

Most of the supplied macros are mainly useful in enriching captured errors with information about the job in which they were captured.

You can create your own, but it requires a reasonably advanced knowledge of the DataStage BASIC programming language as well as editing of a configuration file.