DSXchange

You should declare "FileName" as key and "Data" as the contents of the file in the columns and it should work. DataStage really doesn't know the difference between a hashed file and a directory - both are seen as having a key and a record.

dls,

that is the most common approach used.

Either your tnsnames.ora file does not correctly link to the Oracle instance or your environment is not set up.

Can you connect and do queries via sqlplus at UNIX from the same userid you use for DataStage? If not, correct that issue first, possibly talking with your DBA in order to sort that out.

dhiren, first of all there is no such thing as "URGENT" in this forum. Secondly, I can't see why this question is even urgent. There is no directly plugin for datastage to connect to turboimage. If Turboimage has ODBC drivers to access it then DataStage might be able to go through that channel to ge...

Titto, the instance id is alway provided by the caller, either in a Job Sequence (if you call a multi-instance job the job-activity will let you enter an instance, which may be a variable or a parameter; or when you start a job from the Director or even command-line you may also give it an instance ...

deepthi,

You have just asked a question, which if paraphrased into the car world is "My car is not starting. What is wrong?". In order to get any help you need to give out just a bit more information; mainly: what is the error message?

dhiren, DataStage can perform this conversion, either through explicit mappings (create a list of changes to perform and do it as part of the derivation) or also via implementing NLS (a very big step, probably not necessary for what you are doing). The FTP you use might be able to map, you would hav...

Another method would be to enter "COUNT {HashFileName}"

If DB2Connect is installed then the answer is "yes" (DB2Connect is not free, so many sites do not have it).

Sport,

each job calling the multi-instance job has to use a different instance name.

I you need to do this search repeatedly, you can do a "CREATE.INDEX {TableName} {ColumnName}" and subsequent commands LIST commands on that column will automatically use the index. The CREATE.INDEX command will take a bit of time to create, though.

The good news is that there are quite a few functions available for you to use, ranging from ALPHA, FMT through ICONV/OCONV and substring. The method you choose really depends on what you want to do. If your string always has the format {n-characters}{n-integers} then you can do something more effic...

I ended up calling EXECUTE "SLEEP 30" and that didn't work either; so I finally did a EXECUTE 'SH -C "sleep 30"' and let UNIX take care of the pause. I did a bit of checking and put a SLEEP 30 at the beginning of the program and that did pause, but somewhere in the execution it stopped. The only ext...

Clarcombe, you can used named pipes instead of actually landing the data in files to speed up your processing. Since a named pipe needs both a read and writer it is more prone to errors - if one of the two processes has a problem the whole chain breaks down. If you want to remove the temporary files...

The format for your I-descriptor is :

1 - "I" {I-descriptor}
2 - Num*10 {formula}
3 - MD0 {conversion, here to masked decimal 0 }
4 - NumTimes10 {column header}
5 - 6R {display format}
6 - S {Single value}

I think that NUM won't work as it is a reserved word for a function.