DSXchange

Bala_135, Did you find a solution for this warning message? Pivot is definitely causing this error and even if you pivot a record as simple as 1,a,b,c I get this error. Guessing this might be a bug with the pivot stage. Let me know if you have a solution for this. Searched the forum but couldn't fin...

Thanks Ray! That answered everything.

What I can infer from your reply is It looks like we are on a wild goose chase. Thanks again...

Hi All, First of all let me explain about the project I am involved. The client is trying to build a product something similar to Metastage( I do not know the features available in metastage). The product they are building is an integrator between datastage and business objects repositories which ai...

Hi All, I have problem running a sequencer job which has a routine activity stage. the routine activity stage in the job calls a routine which searches a sequential file for 'yes' or 'no' flags and returns 'y' or 'n' respectively. If the flag is yes then the rest of the jobs would continue or else t...

Hi All, I want to check whether we can suppress warnings or demote them to informational messages in server edition. the message handler manager in tools page in DS manager is not highlighted. when i referred manuals, all i could see was for parallel jobs but nothing for sever jobs. Is there a way t...

Hi All, I want to check whether we can suppress warnings or demote them to informational messages in server edition. the message handler manager in tools page in DS manager is not highlighted. when i referred manuals, all i could see was for parallel jobs but nothing for sever jobs. Is there a way t...

i dont remeber doing a ctrl-c. tell me this thing. i should be executing the command from admin command window right? if yes then i tried from there. there are no locks as i checked.

i am working on windows. but i want to write a routine based on the keymgtresetvalue routine. can you help?

thanks

i am on developer privileges. but is the command in right syntax. am i missing quotes or need double quotes? would be great of you if you could post the source code for keymgtresetvalue.

thanks

it just hangs

HI, Can anyone post the source code for keymgtresetvalue coz i dont have it in the routines in my manager. and also please list the arguments. if that kind of routine does not exist can some one post how to reset the sdk sequences. i tried UPDATE SDKSequences USING DICT VOC SET F1='0' WHERE @ID='SEQ...

what if the first word is less than 6 non space characters? can you please take the same example.

thanks.

Hi, while i try to create a hash file in remote network drive. i specified the path which has spaces for directories. for ex: c:\new folder\some folder.... i get error message saying that the path for hash file should not contain spaces. i tried searching the forum but couldnt find anything. is ther...

the problem is the driving table is in oracle and the secondary or lookup is in sql server. so the outer is on the table in oracle or the driving table so that i do no want to miss any columns which are not matched in the look up table. if matched then get the data from lookup also. i hope you guys ...

hey sorry guys.

i am not being rude. i just forgot to switch my capslock off.