DSXchange

And then there are the friends you haven't had a chance to work with yet.

NULL is never equal to NULL so you'd need explicit "IsNull" checks in the SQL to handle that. Or if the database supports an "NVL" equivalent, wrap both sides of the equality test with equivalent NVL() statements. Make sure you convert nulls to something other than a legitimate d...

Not sure why @VM would not work as the delimiter. Why not use a different delimiter then, something 'simple' like a pipe for instance?

If you are using "value marks" between the fields you should (from what I recall) be able to "unnest" that field during the select of that data and automatically get all values in separate columns. Having it in a lookup may complicate that, I don't know off the top of my head and...

That's a valid point - we have no clue how the OP wants to actually use this total and that answer can change the mechanism needed for this.

@INROWNUM ... @INROWNUM gives the incremental number for each record, but i want the count of the records coming from source You will need to use an Aggregator to get this number "in job" and really shouldn't be a big deal. Otherwise, you'll need to get the count either before or after jo...

@INROWNUM Well, that will give you the record count so far , and you could write out the previous @INROWNUM on a key change to get the count for a key, but you'll miss the last key group. Also, it only gives you the count in this partition . So, no, there isn't really a way. You could reduce the co...

Not sure what you are asking. Those variables will be established in the job's processing environment when it is started. You can check the log's second entry to see all of the environment variables in effect when the job ran. If it makes you feel better, you could take them out of all of those proj...

That doesn't really make much sense, are you certain about how it was created? See threads like this one that explain the expected behaviour.

Per Sainath: 45 client license means 45 different users( with different ip address) can login at any give time. Does it mean if user1 opens 5 differnet client tools (say 2 designer,1 director and 1 administrator window). Will rest 44 users can still open different n number of different client tools...

What Arnd wanted to know was the exact, original COBOL "PICTURE" clause for the field, and we're guessing from the Binary(4) bit it is some kind of COMP-1 field. Can you confirm, please?

Which would generally be fine but it sounds like the Sybase Client installation may not be quite kosher. Perhaps you should re-install it and see if that helps?

We have found that you need to stick with the "recommeded" i.e. supported compilers, otherwise things tend to not work correctly.

So... that makes me wonder how to do the "un" part.

While you may not refer to them explicitly in the job, the stage will leverage them 'under the covers', much like Oracle needs to know $ORACLE_HOME, etc.