DSXchange

Which 'license' are you talking about? Server CPU or client concurrent seat licenses?

I've never used DB2 in my life, so just going by what is posted here. Setting that APT variable would be something you would do for Windows or UNIX, so I'd stick with it as long as it is correct. Another post mentioned that it just needed to exist, so use 'touch' to create one where you set the APT ...

Your table has to be partitioned and you need to be reading from multiple partitions. Sounded to me like you've constrained your query to a single partition.

Welcome aboard but you've put your first post in an inappropriate forum. This one is for discussions on subjects that may become FAQ topics. Questions go in the forum dedicated to the job type, if they are job type specific, this one however should be posted over in the General forum. And when you r...

Take advantage of the $Counter functionality of the Loop stages. This should help if you have multiple lists you need to loop through.

How about?

viewtopic.php?t=131374

The 'educational exercise' was if you wanted to build a looping one-file-at-a-time solution. For the 'all at once' just change the Read Method in Sequential file stage from Specific File(s) to File Pattern and supply the appropriate wildcard pattern.

Your request timed out. Have you attempted to access this service outside of DataStage? There are a number of good tools out there for this, none of which I can remember off the top of my head at the moment (SoapScope?) that can help isolate if the issue is the service itself or something you're doi...

If there's no business need to load them individually (say because you need to log metrics per file, for example) simply load them all at once. You should be fine streaming them through your job. Any 'load issues' will fall more on your target database than DataStage. :wink: Now, we can continue dow...

Sorry, sometimes you gotta do something you may not want to. There's no magic "multiply a field by 1.5" solution other than to "open each and every job and find decimal field and apply multiplication". However, I would hardly consider that a "major change in the code".

Do an exact search for "db2nodes.cfg" and see if any of them help at all. Many are marked Resolved so there should be something helpful out there.

First question - do they need to be loaded individually? Have you considered concatenating them (or using a wildcard pattern) and loading them all at once?

Supported? Yes.

No.

Ask whomever is officially providing you with DataStage support.