DSXchange

Not sure about the issue, try to take a fresh export of that 5th Sequence alone, and import in the new project.

Thanks for the Information.

The rows with the value "N" , in the column UPDFLG are eligible for deletion.

UPDFLG is a non-key column.

Thanks for the Information Ray,

create a mechanism (such as a job or a routine) to give effect to that purge.

How to delete the rows from the Hashed File, from the routine, Can you give some example for this?

I beliver the user role "DataStage Operator", dont have rights to delete the job.

Do you mean Operator , by referring Datastage Director User? if not Change the user rights to "Operator' , so that he can run the jobs only.

Use the routine KeyMgtGetNextValueConcurrent for getting Sequence number. Do whatever mechanism in your job to identify the unique string, use order by in your sql , and use stage variables to identify the uniqueness, or use a lookup to idetify the uniqueness. and for the unique value, just call the...

Search the forum for the keyword "Vertical Pivot", You can use Stage Variables to achive your requirement.

I have a requirement to delete some rows from hashed file based on a flag value (UPDFLG) on a periodical basis. The UPDFLG is a non key , which will contian the value either 'Y' Or 'N'. On regular basis, say once in a month , i need to delete all the rows with the value 'N' from the Hashed File. I c...

Thanks Ray, That Solved the Issue.

Here is the Dictionary Information DICT HASH_UTILITY_LKP 11:51:17 09-02-08 Page 1 Type & Field......... Field. Field........ Conversion.. Column......... Output Depth & Name.......... Number Definition... Code........ Heading........ Format Assoc.. @ID D 0 HASH_UTILITY_LK 10L S P Salary D 1 ...

I tried using K1 : @TM : K2 : @TM : K3 But it is not working. Here is my Hashed File Dictionary http://www.postimage.org/PqNm5w9.jpg And Here is my Hashed File Data http://www.postimage.org/PqNmpti.jpg The output from the routine is TEST #1 ******* Arg1 = HASH_UTILITY_LKP Arg2 = Anand:@TM:IND:@TM:CS...

Hi All, I am analysing the routine UtilityHashLookup, so that we can avoid introducing the Hashed File Stage in the Job. I want to know 1) Is there any advantage in using UtilityHashLookup in terms of memory usage ? 2) How the Key Value (Arg2) has to be passed , in case of multiple Keys. Say i have ...

yes , it is possible. Follow the following steps 1) Install Datastage 7.5 in Server2 in the Same Path as it is installed in Server1. ie Datastage Home should be same in both the servers 2) Create the Project which needs to be copied, in the same path where it is installed in Server1. For ex In Serve...

Introduce a Sequential file in your process, it will actually stop the process until all the rows are read. So your update process will start only after you read your entire input.

There might be some other method also, wait for MASTERS replies.

With dsimport , you can import a dsx file to the server. Search for dsimport in the forum or in help , on how to use it.