DSXchange

I'm running the command

bin/dsjob -server -lprojects

and I get the error

Status code = 81016

If I run

bin/dsjob -server :31538-lprojects

it works fine

Any ideas whyI need to specify this port number ? - its the default port for the engine so shouldn't really be needed ( I think)

thanks

Thanks for your replies. One reason for not setting up the database access system wide was simply to not let people have access to something they didn't need. I suppose that really giving them access to the client shouldn't matter so much - as long as we don't give them a logon then it can't do any ...

Hi, I've got several different application areas who require separate projects on datastage and would all use different database clients, but I want to run them on the same datastage engine. Normally when I configure datastage to use a particular database client I would add specific lines into the d...

A good plan, but I've got to use our 'standard' jobs. (We've got a generic bit of px code to take any file and load it into a table with the same format). I think I might stick a unix script with a sed command to remove "" from the file...unless anyone's got any other ideas. Is there anyth...

Hi , I've got a comma separated file with character fields quoted with "s. I've found some records where there is a section within a character field that is quoted with 2 double quotes. e.g. 1,"some field1","some field with a ""quoted section"" in it",2 T...

If I go to the 'Select Columns' Tab within CFF stage, and remove all the columns from the 'Selected Columns' List, and then add them all back in again, the problem goes away.

I am testing a job which we are moving from version 7.5 to version 8 of datastage. I am finding a difference in the values read by datastage for a particular field in an ebcdic file. I am testing using the same file for the 7.5 and 8 versions of the jobs. The version 8 is unchanged from the version ...

I'll try and get it raised with IBM then.
I've not got easy access to another database yet, but I'll give that a go when I can.

Thank Arnd.

Hi Arnd. I've set up a test job with just 1 key column and using 1 input record which should match with the one record on the table ( both have null in the field I've set as the key in the datastage lookup). If I set the lookup type to 'normal' the lookup finds the record. If I set it to 'sparse' th...

I've got a job which has tries to lookup on db2 using some nullable fields. If I use a 'normal' lookup, the lookup correctly finds the matching row on db2 that has null values in the fields... however, if I use a sparse lookup then it does not find the matching row. Is there a difference between how...

Thanks

I'm trying to understand what happens to sorted data as it gets repartioned. I'm fairly happy to assume that if I have sorted data on multiple nodes, and then repartition it, then it cannot still be sorted. However, I'm not sure what would happen if I had data sorted on a single node and then repart...

Thanks for you suggestion.

I'm going to try that out and also look at trying to get a real ( non-temporary) table created as a staging table, then doing my close command to run the sql as I originally mentioned.

I'll go with whichever method people are more comfortable with here.

Thanks

I'm thinking of using a db2 stage to.. 1. In the open command, declare a global temporary table 2. Use the input rows from datastage to insert records into the global temporary table 3. Use a close command to run some sql using that temporary table. Should this work? When I use a Write Method of 'Wr...

Ray, thanks for the reply. Sorry for the delay, I've had to wait for a premium member to tell me what it said. The Generated SQL seems to give me the warnings all the time, where as the User Defined SQL gives warnings depending on the array size and number of records processed. I guess that if this ...