DSXchange

I'm sure Ray will be along later and can let us know if another of his famous 'Server to PX Transition Labs' will be offered again in the near future...

Just a quick reply - Don't forget that the default in the Sequential stage is to use 'UNIX Style' Line Termination, i.e. just a line feed. Change it to DOS Style (CR LF) and that should get you something more importable.

I missed the 'SET' command... is there something special you need in order for 'Dsjob' to be recognized?

Or just skip the SET and use the full path to the .exe.

Well... in one you fully path the command (which works) and the other you have a relative path (which doesn't work). So, either change your batch file to use a full path to dsjob or make sure the Engine/bin directory is in your path.

Start loop, sure... as can downstream jobs. End loop doesn't need to.

I doubt it. Should be easy enough to test, I would think.

I doubt it was done on purpose, probably part of a control widget change to fix the issue in earlier versions where all columns were initially displayed two or three characters wide.

Open a case with Support. Complain. Perhaps a patch could be arranged.

Don't be sorry about not answering fast, we'll get you whenever you come back. Now, you are allowed to be sorry about not being clear. You didn't answer about the 'compressed' part. Is the compression you are talking about just the COMP-3 fields? Or was there some other form of compression done on t...

Can't be done.

It would be helpful if you could be more specific in exactly what you are dealing with and trying to do with it. It might prevent people from floundering around too much while trying to help. So... what are you saying, exactly? You have a 503 byte character field in your DB2 database. That field hol...

Well, this 'auto creation' behaviour was in 7.0.1, so perhaps something new with 7. I can't really remember when it was we no longer had to Validate jobs to create the hashed files.

Good point about the links...

Did you check the "create file" check box in the Hashed File stage for each link? Curious why this would be asked. It could imply to someone new to the product that you must check this check box in order to have the job create the hashed file, when we all know that's not the case. Now, if you are t...

Wonder if this would help. RowRunningTotal which holds the cumulative values of the job. Yes, because it helps illustrate the use of COMMON variables in a very simple to understand example. 'RowProcGetPreviousValue' is a much more interesting one. However, it does sound like the routine you mention...

Look at the top of any page, one of the options there is 'Contact'. One of the two people you can contact in this manner is our dear Editor.

For 'system date' use sysdate - no parameter required.