DSXchange

Thanks for the info. If the sequence has already been used how would I tell what the next number would be - or in otherwords the last issued number. for reset the recommended syntax was: UPDATE SDKSequences USING DICT VOC SET F1 = '1' WHERE @ID = 'yournumber'; Woudl this update all sequences? Where ...

Want to use the KeyMgtGetNextValue(%SequenceName%) DS Transform

Have the following questions.

How can I determine what the next value assigned will be?

How can I reset values?

Where is the sequence stored?

At what level must SequenceName be unique: job, project, instance?

Thank You

J.

The problem was solved by droping the sequential file stage and recreating it from scratch.

This is version7.0. Perhaps this is to be expected.

J.

Thanks for taking an interest. I'll try your suggestions. Here is an extract of the sql: SELECT ... TO_CHAR(CUST_ORDER_DT, 'YYYY-MM-DD HH24:MI:SS') ... FROM TABLE ... As you can see nothing unusual here. The write sql is INSERT INTTO ... TO_DATE(:9, 'YYYY-MM-DD HH24:MI:SS') Nothing unusual here eith...

Taking DATE data from Oracle 9i and passing it to a sequential file with no transformation other than passing through a transform that merely maps fields - no real transformation. A DATE column in Oracle has a date/time of 2004-02-21 00:07:00. It is being passed to a sequential file and is written a...

Let's say I want to do a theta join (a BETWEEN type join) on a hash lookup file. Is it possible and if so how? I have a table that has a zone column. I also have a hash file that has three columns, zone_low, zone_high and region. I want the hash file join to lookup region based on a theta join. I wa...