DSXchange

What happens if you escape it as in \# ?

Kumar - please tell me what the command line is (apart from the "orchadmin" one I mentioned)? I'm not aware of any other method of doing this so I am curious what option you are referring to.

How can you set a DB/2 enterprise read to something apart from "sequential" and "parallel"?

chowmunyee wrote:...Is there anyone heard index sequential file before?...

This would be an ISAM file - take a google on that and you'll get lots of hits.

Please set the execution mode back to the default value of "sequential" and you will get the results you expect. If you do read the documentation in PX it will explain why the data volume doubled when you went to parallel execution mode on a 2-node configuration.

In you transform stage you can handle this with constraints. The "good" output would if something like "ISNULL(In.ColA) + ISNULL(In.ColB) = 1". This works because a "true" is returned as a 1 and a "false" as a 0, so you can use normal math on the returned values. If your answer is more than 1 (i.e. ...

You can use the UNIX command "orchadmin describe {dataset}" to get the information you are looking for.

At 7.5 on AIX I tried to reproduce it with a server job and a sequence but couldn't.

katz wrote:Well, the error message is 'Abort raised in <Jobname>..Afterjob

Does it help?

Do a "reset" of your job and you will see an entry titled "from previous run" and it will give you the actual error message.

Hello Mahesh, I'll trade you an answer for an answer, my question is "Sometimes when I try to start my car a light blinks and it won't start. What is wrong with my car?" On a more serious note, you will need to tell us some more supporting information. What stage is this, how many node configuration...

DataStage has more string functions than you will normally use and doing what you want is quite easy - if you specify the rules. If you are using a "," (comma) to separate component parts of a string then the FIELD() function will let you do that. But you have also stated that your substring can occ...

Nothing is wrong, PX is probably behaving as documented. You should look into the PX Developer's Guide pages 12-16 ff. This has to do with PX running in Parallel or Sequential mode, your partitioning method(s) and your SQL statement.

You will need to recompile jobs that use a transform stage.

No, not using just one command. You can use the "dsjob -lognewest STARTED" to get the event id and the "dsjob -logdetail" to get the entries in the event id range of the last job run.

What a second here - you seem to be forgetting that databases are designed specifically to enable multiple concurrent accesses and have rules built in place to cater for parallel writes to the same record! You will need to use these rules in order to ensure a successful load and there is no reason t...