DSXchange

Thanks for clearing that up guys. In future I will use the 64BIT option when using CREATE.FILE, however, I have searched the Universe documentation, but there does not seem to be a 64BIt option for CREATE TABLE... So I will have to issue a RESIZE command to create a 64 Bit TABLE. Also, I did a test ...

Looking in UVconfig, there is a flag 64BIT_FILES 0 The comments there say that if you set this to 1 then 64 Bit files will be created. It also says that it is only valid on 64 bit capable platforms. I had taken this to mean that you needed a 64 bit operating system for this, but apparently not. Stil...

There is an SQL_Client_Interfac_Guide.pdf which may have come with your Datastage documentation on your installation disc. This has an SQL client Interface demonstration program on it which may show you how to do it.

I have to create a group of 64 bit hashed files via a script that I can pass to the production team I have no access to the server via telnet (so dvsh is out) so I can create them via a job or an excel script (and paste the commands into DS Administrator) I can do the following SETFILE /applis/psof...

Just FYI, the job control goodies on my site has the major job control function that features compilation of jobs at startup as well as prior to running a job. My point is that compiling a job is not your problem, it's the code calling the compiling routine. That's why I thought clearing the status...

Just FYI, the job control goodies on my site has the major job control function that features compilation of jobs at startup as well as prior to running a job. My point is that compiling a job is not your problem, it's the code calling the compiling routine. That's why I thought clearing the status...

Is it even valid to call DSD.Init after DSR.SUB.JOB.RELEASE ? It is my understanding that DSR.SUB.JOB.RELEASE is the argument that DSD.Init is called with. Anyhow, it was in the code I inherited. I don't pretend to understand what it does. I have tried to log on to Kens website to see if I can get ...

I think found your problem! Remove these lines. Execute "CLEAR.FILE ":DSR.RTSTATUS.FNAME:JobNo Execute "CLEAR.FILE ":DSR.RTLOG.FNAME:JobNo My mass-compiler has this logic, but if you're using this logic as part of job control you can get into trouble whiping out the status infor...

I think found your problem! Remove these lines. Execute "CLEAR.FILE ":DSR.RTSTATUS.FNAME:JobNo Execute "CLEAR.FILE ":DSR.RTLOG.FNAME:JobNo My mass-compiler has this logic, but if you're using this logic as part of job control you can get into trouble whiping out the status infor...

I think found your problem! Remove these lines. Execute "CLEAR.FILE ":DSR.RTSTATUS.FNAME:JobNo Execute "CLEAR.FILE ":DSR.RTLOG.FNAME:JobNo My mass-compiler has this logic, but if you're using this logic as part of job control you can get into trouble whiping out the status infor...

This was actually 'pinched' from Kenneth Bland's KBA Job Control Utilities, comments and all. It even still includes the structures it needs to process an array of job names at a time or that are part of his job control. :? Looks to me like you've got your CompileStatus values bass-ackwards. Zero w...

chulett wrote:

CharlesNagy wrote:(Sorry if the code is not indented, indents seem to have been stripped out in the posting process)

That's what the Code tags are for.

Yup, just tried to repost with code tags, you were too quick for me...

I have been tasked with writing a routine which can be called from a master Job Control which runs a list of specified jobs. We have opted not to use sequencer jobs because our job scheduling requirements are somewhat complicated. My routine tries to attach a job, and if it won't attach it assumes i...

Thanks Guys,

I suspected as much.

Much appreciated, and I will close this topic now

We have a multi processor setup, and would like to analyze performance per job per processor. In other words, which CPU was performing which process. I searched through historical postings on this, but all I could find was reporting by process rather than processor. Perhaps this is not possible, but...