DSXchange

And I have successfully imported the data using the exec command stage, however it seems to not like putting the data into my above parameter (which is defined as a List). Make it a String - List sounds highly inappropriate for what you are doing. Any value that you send in that is not in your List...

No, Arnd meant you have "ruled out #4" because you are dealing with a flat file.

The discussion of 'WebSphere DataStage' and the fact that it does not require any patches includes all of the 'normal' plug-ins. Many of the PACKs require no patch as well, however those associated with Java or a JVM do: Java PACK for DataStage Web Services PACK for DataStage WebSphere DataStage SOA...

ok,but when just select key1 as key in oraOCI and run the job i am getting the warning ORA-01008: not all variables bound I would bet that's because you are not letting the stage generate the sql, which would let it automaticallt 'adjust' to your changes. You are using 'user-defined sql' which is c...

Technically, no. The end result is the same, but what actually happens would be this: 1) 1001,wed. Any existing records with 1001 in that field will be deleted then this record will be inserted. 2) 1001,mnb. Any existing records with 1001 in that field (now meaning the "1001,wed" record) will be del...

Just be aware that, if your input have more that 1 row with the same key value say 1001, you will end up in inserting only the latest one. Where I guess you need to insert both of them. Make sure you understand what Kumar is saying. A second occurance of a key value in your input source will delete...

It's not a UV command.

There's no sorting in the Aggregator. You have to do it outside the Aggregator and then tell the stage that the incoming data is sorted. Lie about the sort order to it and it will blow up. Sort the data 'incorrectly' and you'll basically waste your time. A Sort stage will be the slowest way to accom...

XP Home hasn't been supported for Client installation since the 6.x days. Arnd is referring to the Server product with his 'is not supported' comment, btw.

It's probably just volume. Have you sorted your incoming data in a manner which supports the aggregation? Have you 'asserted' your Sort Order in the Aggregator stage?

If not, then that is more than likely your problem. If you have, then something else is going on.

Where did you add that 'where'? You'd need to talk to your DBA about the nature of those errors. I only ask if it was real as it doesn't really make any sense as a function to me right now. A function is some sort of derived field that you select like any other field from any table - yours will alwa...

Don't have time for a 'proper' answer, but it's way too late to commit in a script - it's done by then. Once the stage is 'closed' your changes are either commited or rolled back, all you can do after that is 'undo' them all. Which goes way beyond deleting new records, typically. I do believe that y...

Add a 'where' clause.

Is this just a... 'play' function?

From the Install and Upgrade Guide: If you want to set up the system so that it distinguishes between product managers, developers and operators, you should set up secondary groups for each class of user. Each user is then allocated to the product manager, developer, or operator secondary group (but...

I have to delete the indexes of a table using routines. No, you don't. You may need to drop them but why do you believe that you 'need' to do this in a routine? As noted, the OPEN command is a more appropriate place for commands of that nature. Another solution, seeing as how most users would not h...