DSXchange

What version of UNIX? Just curious. I want to try it here.

I would do the same thing in BASIC. SELECT into a new hash file. Just run it from a before routine instead of using a UV stage. You could use ExecTCL is you want.

We use a Oracle 8 client with a Oracle 9 database. Works flawlessly.

So here I wanted the data in the following way with out using any ODBC / Database Stages. I mean I dont have any stage where I can write SELECT statement. This is not true. You can use a UV stage against a hash file. That is what it was designed to do. Explain to me why this would not work or it is...

I told you wrong it is "CLEAR.FILE MyHashFileName". This will work in a before job routine.

Older versions of DataStage required the metadata to always be in the same order. Newer releases has fixed this. Yes they can be scattered 3,5,7 or whatever.

There is a check box to clear the file. If the hash file is local to the project the ExecTCL("CLEARFILE MyHashFile"). This routine can be in a before job or called in a sequence. It is included in the SDK.

Keith is probably right but you can run dsjob anytime you want. You could execute it from the other application or write a simple VB front end or a batch file. Do a search there are some cool batch files and shell scripts posted to do a lot of the work for you.

I problem was in the index. I would get everyone out of DataStage and run DS.TOOLS and reindex your files. Usually if you corrupted one file then others are corrupted and you do not know it. Sometimes Universe can repair these on the fly but you may get bad results. Lets say it can repair an index b...

You cannot do a LOGTO because that can break your connection to the project. Do a search on SETFILE, SET-FILE or SET.FILE. You can create VOC pointers with SETFILE. It would be easy to remove tose afterwards. SETFILE will create Q-pointers to hash files in other projects to you can count hem as well...

If you create a composite key in a job then the separator is @TM. There are ways around this but that is the default. So your key should be: Key = KeyField1 : @TM : KeyField2 This has been covered lots of times but maybe under "compound keys" or "muti-part keys". Might be hard to search for. Ray has...

I posted EtlStats on my web site and on ADN. It uses dsjob -report Project Job XML to get row counts, start and stop times. Do a search I explained it several times. It was based on another post on ADN called DSJobReport. You could download that as well. It is not as complicated. You do not need to ...

Vincent

Thanks. Very cool.

Ray has explained this before. I am not sure I remember all the details why but you cannot change a parameter value in job control. I think the reason was the connection was already established to all the dabases in the stages before job control was executed. You have to create a batch job and feed ...

You can you use the search command on the VOC and look for that directory or