DSXchange

It's currently at ADN, but stay tuned...

Welcome aboard! :D

Search is your friend. For example this postasks exactly your question though in the server job forum. Search, also, in the Parallel Job Developer's Guide for "Julian" to learn what date conversion functions exist.

Let's see - you want urgent support late Friday night/early Saturday morning to solve a problem for which the answer is in the manuals and is taught in the entry-level class? This is not the place to be. This is an all-volunteer site, people post here as and when they can. They are not paid for doin...

Just look in the job log for the "active stage finishing" event. All the link row counts are there. Beware, however, that the number of rows written to a hashed file is not necessarily the same as the number of new rows. Hashed files use a destructive overwrite if the key is the same as an existing ...

You can pre-process in UNIX (perhaps through a before-job subroutine).
The number of detail lines in the file is given by expr `wc -l $file` - 2 while the number from the trailer line is given by tail -1 $file | cut -d',' -f2,2

You can read about this subroutine in the DataStage BASIC manual or by typing HELP BASIC !GET.PATHNAME at a TCL prompt. The fourth argument (Code in your example) reports whether the subroutine has been called successfully; that is (for example) whether the directory part is a valid pathname. Check,...

You will, however, have to restart DataStage, doing a uvregen in between, in order for the change to take effect.

You left out TinyInt and all the unsigned variants. TinyInt is one byte (eight bits) long. Signed it can range between -128 and +127. Unsigned it can range between 0 and 255 (2^8-1). You can generalise to the remaining unsigned types from that. 0 through 65,535 (2^16-1) for SmallInt, 0 through 4,294...

Change your expectations. DataStage is NOT a reporting tool. Most business intelligence tools have this kind of capability out of the box. Some databases have a RANK function. If your client insists, resist. Tell them that ETL and reporting are different. They are wrong. Further, as soon as you move...

Sure is - it's in the Oracle DBA manuals, because it's something you do in Oracle. To do it from DataStage you would need to be running with DBA privilege or something quite close. Since paranoia is a necessary prerequisite to being a good DBA you are unlikely to get that. But the DBA can supply you...

Just because you need it in a file doesn't mean you have to use UNIX scripting to get it. You could - more easily in my opinion - create a server job to do this task. With -lognewest you should be able to filter on control messages and identify the newest "job started" message. You can extract the t...

Find me a better term and I'll use it. Lab rats?

Is this a sequential file? If so, is it fixed width or delimited? Is there more in the row than is specified in the metadata for it? Do you have a reject-handling link? What precision do you specify for the decimal? How many digits are there in this field?

One of the biggest challenges for people making the transition from server to parallel jobs is that many of your supposed freedoms (such as the freedom to stick whatever you like into any column and expect the thing still to work) are gone. In parallel jobs you must, absolutly must, confirm to the d...

Watch this site for announcement. The course title is "Server to Parallel Transition". It's aimed at experienced and competent (both) server job developers and aims to equip them with the correct mindset and skill set with which to undertake development of parallel jobs. This is NOT an IILive event;...