DSXchange

I have a table to popluate and key ID field is a oracle sequence . There is a trigger on the table to populate sequence ID. When i try to populate the tabe using Oracle Enterprise , it is looking for ID field in the table regardless of me not mentioning the field in the columns. It throws a error No...

You can call stored procedure in before or after sql TAB in OCI stage .


CALL STPName(Input paramters if you have any);
COMMIT

Probably need a COMMIT if you do not have a implicit commit in stored procedure.

1) Firstly define a variable in the job something like FileDate in job parameters tab and leave the default value blank. 2)In the job sequence , connect execute command stage and job activity stage (call the job which needs the value) Execute command stage: In command tab give CAT in the parameters ...

if i did follow you correctly , here is what you can try , 1) create a job which pulls the date value select to_char( max(pay_end_dt), 'YYYYMMDD') || '.csv' from my_table; and save the result in a flat file say FileDate.txt 2) create a job sequence with execute command stage in it which reads the FI...

Please search the forum , this topic was discussed several times .

Try your search with keyword "Migration".

Good luck !

Thank you ArndW and Ray ArndW- I did try your command "LIST.READU EVERY" and saw only one PID . Then i tried to update the sequence name with new value and 1 record was updated in SDKSequences. Ray - Using your command now i see the new value for the sequence name . I do not know what happ...

Ray ,

As i mentioned earlier , now i am able to see SEQ1 in SDKSequences but when i am trying to update it with new value it ,the execute statement hungs in Administrator.

Any idea why this is happening ?

Ray , Nothing . My main purpose was to start a sequence 'SEQ1' with value other than 1. Since SEQ1 never created or existed in QA project , i ran KeyMgtGetNextValue routine in QA project and gave test value as 'SEQ1' (for example ) and it returned 1. After this i see SEQ1 listed in SDKSequences. Bef...

I am not sure why below command hungs in qa project executing through DSADMIN which was working absolutely fine in dev project . UPDATE SDKSequences USING DICT VOC SET F1 = 'New_Value' WHERE @ID = 'Sequence_Name'; I am not able to update the seqname with new value . I created the seqname using sdk/K...

Change Unix commands to Windows (command line and ExecSH to ExecDOS ).

New line characters if used in routines and custom codes.

Not sure your job scheduling on Unix , Check that if needed on Windows to work.

Thanks it worked fine now .

I gave Field(Execute_Command_1.$CommandOutput,@FM,1) in job parameter and it worked .

Sorry for not doing thorough search at first step.

Thanks
Paddu

Thanks chulett.

I did not search efficiently . Will search the keywords

Filename i need to access has varying timestamp. I am trying to get filename at run time using pattern matching through command prompt. My command in Execute command Stage is dir ETLserverpath\R_test_Product* /B Output from command ====> R_test_Product_200802141522.csv I am passing this value to job...

chulett wrote:Could you let us know which particular values, please? That and mark the post as 'Resolved'? Thanks!

Yes. I agree with chulett ,Please share the solution.

Paddu

Mohandl,

I had similar requirement and my issue was resolved .Please look at thsi
post .

viewtopic.php?t=107975&highlight=

Thanks
Paddu