DSXchange

That will create a select list number 10 with JOBNO values of all records that have a JOBNO > 0, yes.

The correct format was "UtilityRunJob(JobToRun,'Project=':Link1.project,0,0)". What happened when you tried that one (i.e. error message / warning / effects)? The parameter "Project" is case sensitive and must exist in the "JobToRun" job.

I just realized that it was a mnemonic. Use 2 stage variables, first call to get DSGetJobInfo(DSJ.ME,DSJ.JOBNAME) and second one to get the substring from it. Don't use normal derivations, just initial values so it only gets executed one time.

Mqueue series are not files, but data constructs or a communication protocol and I don't think that they can be compressed into files and transmitted.

Var2 = DSJ.ME[1,LEN(DSJ.ME)-7]

Colin, the TCL syntax to select a column is "SELECT {filename} [{selection criteria}] SAVING {column name} [TO {listno}]"

The FTP stage in DS has the advantage that it transmits the data row-by-row. If you gzip/tar/compress your file then it makes much more sense to use the normal ftp from UNIX or (even better) a rcp or scp. You can call operating system commands from almost anywhere in DS.

Sizing systems and software has always been more of an arcane art than a science and with multiuser systems becoming increasingly complex. It is impossible to come up with a formula that is accurate enough to be usable.

Dashpriya - please post a new thread, since your question has nothing to do with the contents of this one.

If you have only one column then the delimiter shouldn't make a difference. Can you write to a sequential file as a test to make sure that the problem truly lies in the FTP stage?

Try using "EXECUTE" instead of "PERFORM" and add in the "CAPTURING ScreenIO RETURNING ErrorCode" and put in a DSLogInfo to show the values of both variables ScreenIO and ErrorCode. This is why I tend to prefer using EXECUTE since it allows redirection and capture of the output.

Did you put these exports into the dsenv file in your DSHOME directory? If not, then changing the setting in your user's environment doesn't affect the background DS processes. If you look into your director log for the file it will echo the environment settings - are the correct entries shown there?

What happens when you append a ';' semilcolon to the DELETE? I am assuming that this gets interpreted as a normal TCL delete statement which will ask for a confirmation - thus causing the "hang".

It seems the difference isn't in the sequential file but in how you are using the FTP stage. Check your EE FTP stage defnitions, most likely you are defining the space character as a special one (delimiter,escape or the like) and this is causing the file to be reformatted.

There are ODBC drivers out there for C-ISAM files; I'm not sure but assume the IBM/Informix have them but there are 3rd party tools out there as well. This would be easier than using a DataStage programming to manually disect the internal formats.

UNIX has no ISAM file structure builtin, this would always be some structure generated by a software vendor. Depending upon that implementation it might be possible for DataStage to read these files sequentially and skip over any internal indexing objects. Do you know your program or application tha...