DSXchange

Before a Distributed file can be defined, the individual hashed files (part files) must have been created, must have VOC pointers (that is, pathed hashed files are not supported), and must have identical metadata definitions. Part files accessed via the Distributed file name are not eligible to be c...

How did such a simple flaw ever get into production? May I suggest that you investigate your test and verification procedures?

It means either of:

You must use the actual column name (not "a") in the columns list.

You must use the actual sequence name (not "seq") as the name of the object whose NEXTVAL method you are invoking.

Search the forum for SCD and "slowly changing dimension". It has been covered a number of times.
And it's straightforward to do.

Your timestamp inside DataStage is a string. You can decompose it with substring techniques, the Field() function, and lots of other ways. Manipulate the pieces and re-assemble. A more robust solution will convert to internal format, adjust, and convert back to external format. intDate = Iconv(L...

Looks like "they" are trying to sell you some consulting time!

The function you seek is FILEINFO.

My query is how do i check for null in a text file? The answer is that there is no such thing as a NULL in a text file. There are no data types in text files, only text. There is usually some convention agreed upon for representing NULL, such as "<NULL>", and you simply have to check for the occurr...

I once created a bitmapped approach - if the bit in the ordinal position represented by the numeric value of the code exists then it was a valid area code. Very quick. Did it in a server job, but it should be quite possible in PX.

Not even PX jobs can necessarily use partitioned tables properly. They have to be configured correctly (the correct partitioning specified, for example). While IBM shared its partitioning algorithm with Ascential, so that working with DB2 partitioned tables in PX is fairly seamless (if the DB2 parti...

You're trying to do too much! There is a control record in the log (//JOB.STARTED.NO) that keeps track of the event number with which each of the past few runs started. Why not use the first item off this list? Read JobStartedList From Log.fvar, "//JOB.STARTED.NO" Then LastStartEventNo = J...

It doesn't matter where your hashed files are. If you are streaming data from them, and you have control over such things, it helps if the data from each can be delivered on a separate I/O channel from the others. That is, separate disk, separate controller, as much as possible. With SAN technology ...

Subject to two very specific conditions, yes. The first condition is that you have an ODBC driver for Excel. If not, stop reading now - you will need to export each sheet as a separate CSV (or TXT) file, FTP them to your UNIX server, and process each file separately. The second condition is that the...

If you are running the job from a DataStage Director, select the Limits tab on the Job Run Options dialog, and change the setting to abort job after 1 warning (rather than the default 50). If you are running the job from the command line interface dsjob , then specify the -warn 1 option after the -r...

I think some memory problem , pl. help I do not have the means to fix bugs in the software, Arun. This you have to report to your support provider, with a reproducible case. From memory you have 8GB of RAM in the machine. Of course, total demand for memory is also a function of what other processes...