DSXchange

Lol - tickets where what we called problems in the support group; it is better to just call them "problems" here. I don't know of a method to just change the DDL of a fileset containing data. You could try editing the actual descriptor file, which will contain the schema used, but I would make sure ...

Pravin, I prefer to let the job finish and then use the DSGetJobInfo(), DSGetLinkInfo() and DSGetStageInfo() routines from a job sequence or DS/BASIC routine to get this information. If you really wish to do this using just the stages shown and no after-job routines or other calls, you would need to...

The REINDEX is likely to help you in this case, since (a) you can do a COUNT and (b) the error is shown in a SELECT subroutine. Since you need to get rid of all users, reindexing ALL is preferable.

Yes.

What is your target? are the two flows in the same job?

One CPU? Not only is that not visible from any job design, but it is irrelevant.

There are two builtin commands that do this, uvfixfile and fixtool; whereby fixtool is the newer tool and preferred over uvfixfile. Both can be called from the UV command line or from the shell.

devidotcom - so it seems that there are two basic choices. You going for the premium membership or Ray posting the answer as non-premium. if I were a betting man I'd know on which one I'd be placing my bets. The Premium costs is not excessive and I have yet to see a single post in this forum where a...

Your problem isn't directly with the metadata. Converting from EBCDIC to ASCII will have changed the packed binary field values; you will need to manualyl convert back to EBCDIC and then unpack them before these columns are useable.

There is a file called dsdlockd.config in the DataStage home directory that you can edit to enable the daemon when starting up DataStage.

I would recommend having your DBA create a sequence for you. This is what they are designed for and doing it another way is going to be more work to write and much more work to maintain - particularly when things go wrong. You could use the server key management routines as Craig suggested, or you c...

Hello and welcome to DSXChange wengad.

There is no facility for deleting jobs from the command line programs.

The question wasn't how to get that information, but if it could be done from dsjob.

I would start with making sure that the main job doesn't get aborted for some other reason . Normal failures are handled appropriately by the control mechanism. Another approach is to enable the deadlock daemon; that way the processes are automatically cleaned up within 15 minutes (default setting, ...

I usually catch myself before doing a duplicate post, but I've noticed that there are many such posts in recent weeks with a growing tendency so thought that an automated approach might work.

Specifically which warning are you asking about? PX/EE has the ability to deprecate or suppress messages and you might wish to go that route.