DSXchange

If your truely on PX then in sequential file stage, under format tab, you have Type defaults. Under type defaults you have String. String has a property Export EBCDIC as ASCII. Look into that. This property will enable you to read a binary file via sequential file stage.

Inside your project folder, where you have &PH& and &COMO& folders, you will have another file by the name DSParams. Kumar is referring to that folder.

just4geeks wrote:

DSguru2B wrote:What happens when you remove the -wait and just put -jobstatus?

Yeah, it worked.

Is that what your looking for Ray ji ?

ewu wrote:It worked. Trailing space is causing the problem. Thanks a bunch to all of you.

Kinda figured. When everthing looks perfect and stuff dont work, go back to basics
Time to mark your post as "Resolved".

The routine I posted hereruns getCMD on UV which is sql on a hashed file. I even gave a full description. If thats hard to follow,then as Craig advised, load your file in a work table and do the sql and get done with it.

Thats why Craig is my mentor

On hashed file. How you are doing for median in the routine.

Make sure you have 2 digit month. I explained this in your other post.

Thanks for the encouraging words Craig. Nice to see you mention my name although I, really am, the new kid on the block. Kim, I absolutely agree with Ken and his methodology, infact, I am always waiting for his long answers, for I think , each line in the para holds tremendous amount of insight and ...

Use version control. If not, then keep exported copies of working, finalized jobs. And some would say, find the person who did it and kill 'em.

The technical manager in one of the teams at my current site was talking highly about this feature. He was very impressed.
Coming back to the original topic, for now, your stuck to a command line diff or a comparing tool.

-report is as good as the jobinfo but gives much more details then the jobinfo. It has got three return values as jobinfo 1 - finished OK 2 - finished with Warnings 3- Aborted. 99- Job not running. I understand if the stats of 1-3 indicates that the job is in executable form, that implies that it i...

Or load it in a hashed file, the duplicates will be eliminated by itself. Use the sql to get the particular column in sorted format, then do your count and top 10 percent calculation.

O yea. I , also forgot to mention, you dont need to change integer to string in order to concatenate it. The DecimalToString() was the culprit. Get rid of it and you will be fine. If you noticed, I did the same for the second piece.

Time to mark your post as "Resolved" then