DSXchange

Thanks Ray,
but neither of two options worked. And Listener log doesn't help.
I have FileSucceededAction=cmd /C del "$FILE" in RunImporter.cfg and works fine.

Regards, Cecilia

Hi I want to set an action for RunReceivedAction in listener.cfg but nothing works. I wanted to set RunReceivedAction=cmd /C copy "$FILE" Dir1 I attempted too with RunReceivedAction=cmd /C del "$FILE" in order to isolate if the problem was related to sintax command and it didn't ...

Thanks a lot to both, I'll go with these arguments with the customer. We want to define some standars for our consultant people too and this was an issue when defining it for use in this customer, besides for the the fact that DS looks like Batch jobs could be unsopported in future and we are moving...

Hi all My customer is working with DS in Windows environment and uses ControlM to schedule DS jobs. I wanted to have more control about jobs execution interaction writing my own flow with Job Sequences job, but he says that ControlM can't launch Job Sequences jobs and that all logic must be put in C...

Hello Henrique I have bad news for you. I posted in this forum about this topic and opened a case in Ascential too. Ascential answer was: We could enhance the product to use the newer task scheduling process, however that would require a significant amount of development and has to be considered in ...

Thanks a lot for the reply. Keneth, I have a doubt yet: when I run CLEAR.FILE &PH& the file .uvnlsmap remains in the directory, in that way it's a bit different from delete all files manually. I guess it doesn't matter if .uvnlsmap exist or not, it will be recreated when a job run again, Am ...

Hi I have the recomendation of use CLEAR.FILE &PH& as projects maintenance. I have 3 questions about this: 1. Has this command the same efect than delete "manually" all files in &PH& directory? or does it make something else? 2. If the answer to 1 is that it does something ...

Hi Peter Late, but I want to share with you Ascential support reply to my question (case #379252) of alternatives to this restriction in DS 7 with Windows 2000 (for Windows NT Microsoft provide a solution). No change has been made to the product so unless Windows 2000 has lifted the restriction then...

Hi all I'm grateful for all your messages. Actually, I didn't want to answer in order to "finally put this subject to rest", but all of you deserve my gratitude. Sorry, because I misinterpreted the phrase "It follows that no key column in a hashed file can accept NULL as a value"...

Also, if you have a multi-part key and one of the "parts" evaluates to the NULL.STR or NULL this is ok too, although you may get results you were not counting on. As Ken points out, check for this condition in the constraint and take appropriate action. Regards, Michael Hester[/quote] Sorr...

Thanks Kenneth and Mike, and apologize ap_nat for take your case for introduce this situation
Saying this, I will check with Kenneth and Mike information in mine, but the jobs loaded hash files and aborted when they inserted null value from hash key to the database.
Thanks again, Cecilia

You probably didn't paste the whole message. You sure you aren't writing a NULL primary key value on a row? Is there a constraint to check for this and prevent it? But, Kenneth, DataStage accepts null values in hash key, from 6.0 version, doesn't it? And much more besides, it accepts them in the ca...

Hi all I was looking for in the forum, but I couldn't find information. Sorry if I would be reiterating. I want to run periodically a Clean Up of the project, scheduled from Control-M (as we do with dsjob), does somebody know the command line? Besides, do you know how do that with DS.REINDEX ALL in ...

Thanks Ray I still have a question. The creation worked fine when I logged as DataStage administrator, but in other case DataStage/SQL: "FOCUS\cmachado" is not an SQL user is the return message. How could I sign the user to DSExecute or what permission (less than administrator, of course) ...

Usually, in the second job, the idea is that you refer to the dimension (loaded in a hash table) by code in order to get the ID and so on for every dimension.
I suggest you to read The DataWarehouse Life Cycle by Kimball in order to get a reference for the used terminology and best practices.
Regards