DSXchange

Bala, did you mean to say "rows" instead of "columns" in your post? The View-Data facility in the designer only shows a certain number of rows (configurable) so you might not be seeing all of them in that view. The dataset management utility (which can also be called from the command line via "orcha...

Kumar,

no reason to be confused - you cannot change a job's parameter values within the job itself.

Vijay, the DataStage function ICONV() to CONV ert to I nput format and it's opposite number, OCONV(), have enough date handling formats to cover just about any representation of dates in use, they not only will tell you if a date format is incorrect but in some cases the ICONV() can even attempt to ...

I think you were thinking of "The return of the Giant Man Paste"; or perhaps the perrenial "The Lamb Lies down on Man Paste"

Somaraju, the UNIX "sort" command will let you sort on different fields, with or without the option of removing duplicates. The same applies to the DataStage SORT stage; you can choose your columns to sort on. As you've already stated, you need to sort prior to splitting the file into smaller ones. ...

Craig,

click on the grid computing icon in my signature line, then the web page has a couple of options on different ways to view the team results; most of them will give you the list of members.

D- sounds like the title of a Genesis Album Thanks.

Seanc217,

good for you; I've sent a number of e-mails to get a beta version and IBM/Ascential hasn't even bothered to reply

Does this error happen each time? Are you doing any division of numbers in your transform stage?

Divine, if nobody has answered your question they either don't know the answer or don't want to respond to it. Continually asking for updates or demanding answers won't work in this forum. I think you need to call your support provider now. Good luck, and please post your answer here so that others ...

The Parallel Job Developer's Guide chapter titled The Parallel Engine Configuration File is a really good place to start.

Jayant, at version 7 it is not possible to change a job's parameter values from before-job code. In order to do what the poster wishes to do, the parameter file needs to be read as part of one job or sequence, the parameter values separated out and then the actual job called with these parameters.

You cannot modify your parameter values inside the job itself.

Check your autosys script, it looks like the 10th dsjob run specifies an invalid project name.

Per the Oracle OCI documentation, you need to declare the datatype as LongVarChar in DataStage for CLOB database columns. Could you try that and see if you still have an error?

Ray & others, I think that for those of us who have used the UniVerse engine in the past the locking mechanism is understandable and, because of practice, clearing out errant locks and defunct processes from TCL and/or using ipcs commands is almost second nature. But for the majority of those wh...