DSXchange

Nice work, Vincent.

It does nothing. You can put pretty much anything there.

Version Control.

It is on the server not the client.

Capture files are created by the execute command with a capturing filename option. The filename is being written to while you are trying to delete it. You can do this on UNIX versions. If the command has a lot of output then this file can be quite large. The output is what would of normally went to ...

IBM could make ELT work if they combined all their database technologies. If they used Redbrick to stage and then made it seemless to integrate with DB2 or Informix then these would need stronger transformation or use DataStage to transform. Redbrick load times are amazing. I think Oracle has the be...

The CLEAN.ACCOUNT command will sync the VOC with the files underneath. This maybe the easiest way to sync them up. Do not delete anything if you run this command.

Ray is correct as usual. These are all Universe commands and understanding how Universe works.

Your VOC is out of sync with the OS. The OS has the D_ file and no VOC entry. You need to delete the D_ file probably so it can create the file.

There is a routine on my tips page called KgdDebugMetadata. This is designed to read small sequetial files completely into memory and check the lengths of each column to see if any are too long. It should get you close. You need to change the openpath to openseq and the read to readseq.

Do a search for TCL commands or DS_JOBS.

First you need to access the metadata. You can try to extract it from the job design in DS_JOBOBJECTS but that would more diffucult than getting from DS_METADATA. You need to save your column definitions to get them into DS_METADATA. I posted the code to extract the metadata from DS_METADATA and cre...

There are q-pointers and file pointers. A q-pointer could create a synonym to a DataStage repository table or "resource".

Nice, can I quote you?

The post is my user group so it is not available to all. It maybe on my tips page. It is called KgdCopyParam. I think Ken's is on his web site. It was posted on the www.datastagexchange.com. Not sure if it is still these.