Surrogate Key using sequence ?

swades · Post by **swades** » Fri Jan 19, 2007 1:13 pm

Hi,
I am Really stuck please help me..
I have job which generates surrogate key using Surrogate_key_gent_stage, I want to maintain surrogate key in multiple run, I search in forum I found that I can do with Sequence BUT can anyone please tell me how to retrive Last_run_max_value of surrogate key in sequence please help.

DSguru2B · Post by **DSguru2B** » Fri Jan 19, 2007 1:37 pm

Parametrize the start value and provide the start value during run time. You can store the last generated key in a file. During run time, the contents of that file can be passed to the job parameter.

swades · Post by **swades** » Fri Jan 19, 2007 7:08 pm

During run time, the contents of that file can be passed to the job parameter.

Can you please tell me how to do this ? I have read this..in other forums But I want to know how ? please let me know..

DSguru2B · Post by **DSguru2B** » Fri Jan 19, 2007 7:29 pm

Well, write your max value a sequential file. Build a sequence job which has two an command activity stage. Pass the command

Code: Select all

type your/fully/qualified/filename

Have a link coming out of command activity stage to a job activity where your calling your job that generates the keys. Open the job activitie's poperties, in the expression for the job parameter, double click, right click, choose execute_activity.$Return_Value.
Thats one way, i am sure there are other ways. Atleast this will get you started.

swades · Post by **swades** » Sat Jan 20, 2007 5:38 pm

I did that and sequence is running fine. BUT output of command is giving me wrong value what can be reason ?

In command_line, I am passing path of my .txt file which contain only single digit and that digit I am passing as parameter of next job_activity..BUT output of this activity is giving me wrong value of that parameter...so please what can be the reason or Is that I am doing something wrong ?

DSguru2B · Post by **DSguru2B** » Sat Jan 20, 2007 6:00 pm

Did i say $Return_value. SOrry, you need to pick $Command_Output.

swades · Post by **swades** » Sat Jan 20, 2007 7:35 pm

Thanks for the Replay.

When I am using Execu_command.$Command_Output as value, then the Sequence gets aborted...what can be reason ?

DSguru2B · Post by **DSguru2B** » Sat Jan 20, 2007 9:17 pm

What does the log say?

chulett · Post by **chulett** » Sat Jan 20, 2007 10:30 pm

For anyone playing along from the home audience, there's no underscore in any of these trigger values. It shouldn't even compile like that, so I'm sure everyone is using them properly but typing them incorrectly here.

We now return you to your regularly scheduled problem.

ps. swades - you need to tell us what the reason was, only then can we help.

DSguru2B · Post by **DSguru2B** » Sat Jan 20, 2007 11:59 pm

Thanks for the clarification Craig. I couldnt remember the exact options off of my head as i havent used that option in ages.

I hope the OP is actually choosing those options from the drop down rather than typing it, which he probably is as the job ran and aborted.

swades · Post by **swades** » Sun Jan 21, 2007 12:00 am

What does the log say?

is:
Message:
k_ren..JobControl (@Execute_Command_2): Executed: /demo/...../filename.txt
Reply=320
Output from command ====>
SH: /demo/....../filename.txt: 0403-006 Execute permission denied.

AND
Message:
k_ren..JobControl (@Execute_Command_2): Command /demo/......../filename.txt did not finish OK,
reply = '320'

We now return you to your regularly scheduled problem

I am sorry this is not scheduled problem

chulett · Post by **chulett** » Sun Jan 21, 2007 12:07 am

You were supposed to 'type' the file, not try to execute it.

DSguru2B · Post by **DSguru2B** » Sun Jan 21, 2007 12:08 am

Did you put 'type' before the file's fully qualified name? Does'nt look like it. Put type before your file name.

DSguru2B · Post by **DSguru2B** » Sun Jan 21, 2007 12:12 am

chulett wrote:You were supposed to 'type' the file, not try to execute it.

Beat me to it

I_Server_Whale · Post by **I_Server_Whale** » Sun Jan 21, 2007 12:12 am

swades wrote:
We now return you to your regularly scheduled problem
I am sorry this is not scheduled problem

I don't think you got what Craig meant in that sentence. First, a general announcement was made about the trigger values and then the audience were directed to regular flow of solving the problem.

Craig! Correct me if I botched up.