DSXchange

Make sure that all associations of multivalued fields are properly defined in the file dictionary (as well as in the column metadata that DataStage uses). In this case, BASIC is almost certainly not the most efficient method. If you're using a hashed file stage or a UV stage, choose "normalize on" a...

Check out the help on DSAttachJob function. By default, in job sequences, this is set so as not to propagate back to controlling jobs when a controlled job fails. You can change the second argument so that it does.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

I'm a bit confused on this one.
You (eventually) call DSSetUserStatus to store the user status value?
On what evidence do you assert that "it does not work"? How are you attempting to retrieve the user status value for that job?

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

And, you will also find, the driver no longer works. The drivers supplied with DataStage are licensed only for DataStage components (e.g. ODBC stage) to use. The licence does not cover use via BCI functions. As the message says, you need to purchase a licence if you wish to continue to use the drive...

The NLSMODE parameter in the uvconfig file turns NLS on or off. You need to regenerate the disk shared memory segment image (uvregen) then stop and re-start the DataStage services. But what is it you're trying to accomplish? As I posted earlier, you may be able to use BCI functions to communicate be...

Au contraire! You will not get this message unless you have NLS installed. And it means exactly what it says; one or more characters found in the data that could not be found in the NLS map for that link or channel. You might try changing the map to NONE to investigate what's happening, since it's o...

Just for variety you might try a MATCHES operator. For example:
link1.EmployeeNum MATCHES "3X'5'0X":@VM:"3X'8'0X" And Not(IsNull(link1.EmployeeDept)) And Trim(link1.EmployeeDept) > " "

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

The drivers give 30 days "free" use, then start generating this warning. The only way to turn off the warning, if you want to continue to use the drivers, is to buy the licensing. This has been bought by Ascential to allow the drivers to be used by ODBC stage types and the DS_CONNECT command, but fo...

DELETE.FILE work like DROP TABLE. Including the DATA keyword serves to preserve the metadata (= file dictionary), but still destroys the structure in which data rows are stored. To delete rows (records) from a hashed file, you can use DELETE (either SQL or RetrieVe verions), or CLEAR.FILE to clear a...

The command for deleting a hashed file depends on how it was created and whether it's static or dynamic. And, possibly, the operating system (UNIX or Windows). If it was created with CREATE.FILE, it is deleted with DELETE.FILE. If it was created with CREATE TABLE, it is deleted with DROP TABLE. If i...

Take a look at the file JOB.1730727197.DT.1304256656.TRANS1 in the subdirectory RT_BP13 in your project directory, and let us know what's happening at, and for a couple of lines either side of, line 175. This should shed some light on that "improper data type". These are usually caused by an "opaque...

The dsjob option you require is -logsum.
This gives you -type and -max sub-options.
It's all in the manual!

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

Kim,

DELETE does not reclaim the space in a Type 30 file. It merely marks the space as free, able to be re-used. The only tools for reclaiming the space are RESIZE or COPY.

Regards,
Ray

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

There's lots of material on Ascential's web site.
http://www.ascentialsoftware.com

In version 7 (now out), MetaRecon is called Profile Stage, and INTEGRITY is called Quality Stage.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

Reply to Q2 only: You can use SQL statements (INSERT, UPDATE or DELETE) on hashed files, provided that their column metadata are in place in their file dictionaries. A WRITE statement in BASIC performs a destructive overwrite of the record whose key value is specified. You can read the record for up...