DSXchange

I would go so far as to say 60 well-named stage variables with well-thought-out and efficiently-written derivations. Sure wouldn't want to see anything like this: if input_link.thedate = StringToDate('1299-01-01') then 'NULL' else if input_link.thedate >= StringToDate('2000-01-01') and input_link.th...

I tested the following logic in an 8.1FP1 environment on RedHat and did not have any problem. APT_String mystring = "MC Daniel"; mystring = "ABC"; However, I did recreate the error when I added this line after the above: mystring.replace(3,1,"Z"); ##F IIS-DSEE-TFSF-0000...

Are you using the substring or replace functions of the APT_STRING class in your operator? If so, the error is indicating that you are attempting to access a substring that extends past the end of your current string. APT_STRING string; string = "ABC"; Using offset 3, span 1 with "ABC...

Does table B have indexes for column1? Sparse lookups are generally slow to begin with, unindexed tables will slow that down even further. Sparse lookups are recommended only when the reference data quantity is much larger than your source data quantity (orders of magnitude usually). I personally do...

Hi As part of installation 'dsadmin' is the administrator userid we had, and it got deleted. Thank You So you're saying that dsadmin was also the only IS suite administrator account and that a separate IS suite administrator account (i.e. 'isadmin') was not also created? The publicly available Info...

As part of a standard installation, there should have been created an IS administrator userid. Normally this user is named isadmin. Assuming that this user still exists, you should be able to recreate your dsadmin userid for DataStage.

Regards,

You could use three jobs, but you do not need to. As already mentioned, in one job you can either: 1) Create all three files 2) Create only the final file (with header and trailer) The logic to create the header and trailer records will be identical in either case, the difference is whether the job ...

isvalid() requires a string value, so: Convert the decimal to a string Use isvalid() to test the validity of the string if valid then convert string to date If the decimal is nullable be certain to handle nulls first in your logic. IS 8.5 has expanded the functionality of isvalid() and has added typ...

What are the triggers on the first job activity?

Do you have any warnings in the log for the first job?

Regards,

As was stated in that thread, the quoted documentation that was referenced by the OP was specifically for InfoSphere Balanced Optimization , an optional licensed add-on to Information Server. The context in which APT_NO_SORT_INSERTION is mentioned here can be misleading as to it's actual purpose. sa...

The best partitioning method to use depends on your business rules and your data. The goal of partitioning in a parallel environment is toreference distribute the data among the nodes as evenly as possible within the rules of the task being performed. What is your key column being used for? There ca...

When you run the "ls -l" command in the datasets directory, how many files are listed when the command returns? Does the command hang if you run it in another directory? High I/O waits are usually caused by one or more of: 1) Hardware contention (I/O channels, disk drives, network for NAS)...

If your query, apart from the schema name, can change from run to run, you will need to build the final query before the job is started. DataStage will not replace parameters embedded within parameters. A Basic routine called by a job sequencer should be able to handle that for you using the EReplac...

Start diagnosing the problem by answering the following questions: How is the column defined within the database? How are you viewing the data that has been loaded into the database? Using the db's client software (or other), or view data (or similar) within DataStage? Have you tried other methods o...

cat will work in an Information Server 8.1 installation on Windows. The MKS toolkit which is installed with IS provides many Unix commands, including cat.

Regards,