DSXchange

Currently we are using encryption function in netezza to achieve this, as the target DB is Netezza .But now the requirement has changed and we need to use encryption function (built in) in DS. In Informatica we have AES_ENCRYPT and DECRYPT to do this. So I was curious, if the newer version of DS has...

Hi All

Is there any built in function available in datastage to encrypt and decrypt a field present in a *.csv file?

Thanks,
Snehal

I am trying to get the Input and Output Links from a job using the build-in function DSGetStageLinks(JobHandle, StageName, Key). While compling the routine, below errors have been returned. Code: LinkDtl = DSGetStageLinks(JobHandle, StageName, Key) Errors: ',' unexpected, Was expecting: '!', ')', '=...

I have to capture the Job execution details in Report format with all the statistical data like the read, write, lookup, or failure events that occurred during a job run on each link/stage. Alos the timestamp of the run and the number of rows that were read or written. I came to know that, these det...

Error: DSD.UVOpen An operating system file already exists with the name "D_HASH_ABC".File name = File not created..| We have hash files which dont have corresponding data files.These data files have been accidentally deleted.Now there are only traces of them present which are D_HASH_ABC .W...

This is definitely an error related to oracle.Try to do select count(*) from table and run the query in toad.I am sure you will not be able to run it.
or run the query in the toad and in the data grid do a ctrl+A.You will get the row which has the issue.This is not a datastage error.

We have migrated to new server and we are facing this issue when run a job (existing jobwhich workes in the old server migrated to new one) we get the below error main_program: Fatal Error: Could not connect to datasource?? (-1; nbkkdyf; CRD_DFRW; [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver]...

It might be worth re-indexing your repository using the DS.REINDEX ALL command. Search DSXchange for details of how to use this command. In particular make very sure that you have exclusive access to the project. We did the REINDEXING for that project.But no luck :cry: . However have raised PMR wit...

Thanks Craig for your reply.We are using 8.1 and have all the fixpacks that IBM has suggested installed.
Can you suggest any other solution that I can try before going to IBM support.

I have refreshed the director and also have opened the new director connection to see the remainder jobs.But no luck.Still the deleted jobs appear in the director. When I try deleting it from designer I get error Unable to delete the items .Delete object for \$Job_path\$Jobname failed Error calling ...

I tried deleted some jobs and sequences from designer.But they appear in director.When I delete the job from director>it gives error telling that the Job cannot be found in repository. How do I delete jobs in director and designer both ( I need to synchronize both director and designer).