DSXchange

In the Job Control or wherever ou wish to trigger the clearing of the file, you can specify:

Craig, I've been trying to get that answer since the first reply. I thought it was a HASH file, and if you do 2 or more writes to the same file from a transform you might get contention, so I like to do an external CLEAR.FILE; but since a sequential file can only be opened once for writing that cann...

snassimr,

you cannot use the CLEAR.FILE command on a sequential file.

You will have a tough time editing the .uvconfig file, as it is binary. The uvconfig text file changes will not be used by the engine until you stop datastage, execute a uvregen and restart the server.

snassimr,

please tell us your EXECUTE command. It normally does not hang.

Also, please tell us if you are trying to clear the contents of a sequential or a hash file.

The problem intrigued me, so I wrote a program that write 2.5Gb to a sequential file and then tries to read it using READSEQ. The last 100 lines contain different information and the READSEQ correctly read this; so READSEQ does work correctly with "large" files. -Arnd. For those interested: OutputSt...

Are you trying to clear a sequential file or a HASHed file? the OPENSEQ and WEOFSEQ are, as might be guessed from the names, functions for sequential files. There is no BASIC language statement to clear a hashed file. The TCL command is "CLEAR.FILE <filename>"; you can execute that from a before-job...

Yes, you can do it via BASIC, an OPENSEQ then WEOFSEQ will do it for you. But the job has the option to clear the file, plus you might also put in a "rm <filename>" as an external call before a job.

Dralair, DS doesn't really know how many CPUs a system has - it's only interface to the "real" world is through the configuration file. The actual distribution of threads and processes across the CPUs is done by UNIX and cannot be controlled externally; a physical machine can, depending on HW and OS...

Vinay,

all Multiinstance jobs allow you to set the instance name in the directory when you start the job. The field does not appear for non-multi-instance jobs.

Hello Lagrange,

there is not GUI setting for this, but each project has a file called dssendmail_template.txt which can be customized.

I just wrote an empty server job (on AIX) with one line in the job control: CALL DSLogInfo('My PID is "':DSGetJobInfo(DSJ.ME,DSJ.JOBPID):'".','') and I get the UNIX pid returned to me correctly. If you try this from the manager in a test run for a routine it won't work (since you are not inside a jo...

cse,

no, it is just the offset argument that uses a small integer; the READSEQ doesn't need to point to any absolute location in the file.

Try another command,

"C:\Program Files\Ascential\DataStage7.5\dscc.exe" /h bigmachine /u arndw /p topsecretdoubleprobation /r * myproject


(this will compile all routines in project myproject)

Do you get the same error?

No, no separate file. I assume that you can use your DS clients from this PC without a problem, right? It looks like a syntax error, but it works on my system in the same format. Might you have any embedded blanks or special characters in the command line? Try -lprojects option without giving a proj...