DSXchange

For the sort & variable way, you guys will lose the last record. So only hashed file works.

Thanks,

Hi, Where do you guys code the following function: Datastage Designer or Datastage Manager? The error is: 0002 Function ReadParam(Arg1) ^ "FUNCTION" unexpected, Was expecting: Array Name, Variable name, When you compile it with Datastage Designer. Thanks, ==================================...

If p$2$1 is set as the following:

p$2$1 = 'DB':'_':DATE.TAG(DATE())[1,4]:DATE.TAG(DATE())[5,2]:DATE.TAG(DATE())[7,2]

When the job is compiled, the error below is occurred:

"Error compiling Job Control Subroutine conn. "

conn is the control job name.

Any idea?

Thanks,

Hi Craig, Thanks for your quick resopnse. I try to wrap it in a control job, but still do not know how it is handled. The code is as the following: L$2$START: *** Activity "JobActivity_1": Initialize job jb$2 = "testit" h$2 = DSAttachJob(jb$2, DSJ.ERRNONE) If (Not(h$2)) Then msg$...

Hi There, If the database naming keeps changing every day when it's read, like the db name DB_20041020, how can you handle it? For example, when DB:'_':DATE.TAG(DATE())[1,4]:DATE.TAG(DATE())[5,2]:DATE.TAG(DATE())[7,2] is used as Database in a DB stage, it doesn't convert to DB_20041020, it keeps &qu...

Thanks, It works.

It's too late to do so because the lookup looks the hashed file first and finds an entry. But that's not right. At the beginning, the hashed file should be empty in order to guarantee the correct result.

Thanks,

Hi there,

Before run a job, how can a hashed file be cleared which is created in a previous run? If it is not cleared, the looking up from the hashed file will be wrong.

Thanks,

The code is

SELECT * FROM IDBA.PLAYER WHERE PLAYER.FIRSTNAME=? AND PLAYER.LASTNAME=? AND PLAYER.POSTALCODE=?

Hi there, A job needs to insert a record into a table. before inserting, the table is searched to see if the record is already in the table. If it is, brings back its primary key. The Database is DB2 7.2.9. When the job is run, it hangs up. How can the transaction be set to allow the search and inse...

A DB2 database cataloged remotely is only effective within an instance. Outside of the instance, it is invisible. The problem is how to associate the Datastage server with a DB2 instance, and how to determine which DB2 instance is associated with the Datastage server? Can a Datastage server be assoc...

:?: Hi there, When a hashed file "pre-load file to memory is Enabled", a warning message as the following is showed. This hashed file is very small (only three rows in it). It doesn't need 128M cache. In another case, the problem is - Unable to allocate memory - means not enough memory for...

[quote="ray.wurlod"]Or, even better, construct a DataStage job to do it for you, and run that - with as many parameters as you wish, from your code. The job can move data to and from sequential or hashed file(s), both of which are readily manipulated - without licensing - by DataStage BASI...

Hi there, When a job consists of several processes and is run in a single processor machine, how is it run? Are these processes run in parallel or one by one? For example, these process are as following: process1 -> process2 -> process3 How are they run: all three processes start at the same time an...

Hi there, We are trying to build a data mart which master controlling job is based on three database tables. One of them is dynamic which is built just before the master job starts to run. So Datastage job control code will be used to write the master controlling job. The problem is how to access th...