DSXchange

Do a search. This has been covered. I think there is even a FAQ on hash files.

You need quotes around CHashedInput and you need to fill in the CATEGORY instead of xxx.

The MINUS command is also powerful.

You can make a category export from a full by modifying DsxSplitter.pl posted here. I have one written in BASIC as well.

Roy

I think that solves the problem but that wasn't the question. They still cannot run a routine directly from a shell script. They can only do it from a job or other BASIC programs.

Here are 3 posts which should give you an idea.

http://www.dsxchange.com/viewtopic.php?t=88999
http://www.dsxchange.com/viewtopic.php?t=87413
http://www.dsxchange.com/viewtopic.php?t=87580

Any time you need a parameter in this way then you need a batch job or routine to calculate the parameter and feed it into the job. Plus there is usually a job which needs this file so it needs the same parameter. It complicates several jobs. Most of the time you are doing this to archive the file w...

You can do it this way: If <condition> Then <Stmt1> Else If <Condition> Then <Stmt2> Else <Stmt3> I have also seen it this way: If <condition> Then <Stmt1> Else '' : If <Condition> Then <Stmt2> Else <Stmt3> This seems a little clearer. Each IF returns 2 values. The first IF returns <Stmt1> or '' whi...

This is easier to do in a batch file or a shell script in UNIX. Do a search this has been covered a lot.

Arnd is correct. You need a job that calls this routine. It just needs 2 lines of code the DEFFUN statement and the call to the routine. The job needs no stages just job control code.

May be you can post the code extracting non-key field from hash file Why you want to do this? The purpose of a hash file is to use keys. If you are reading parameter values then the key should be the parameter name. The value should be field 1. ParamName = Arg1 open "MyParamValues" to Par...

I don't think so. That is not what the Java Pack is for. Universe 10 supports JDBC. DataStage is based on version 9 of Universe.

This is really bad. Two people beat me to the post. I am really slow today.

DataStage comes with its own database. Originally the database was called Universe. Now it is called the DataStage Engine or DSEngine. You have to extract data from a source to put it in a hash file. There are many hash algorithms to choose from but DYNAMIC is the default. Parallel Extender version ...

RedBack is cool. Sorry, not paying attention.