Surrogate Key using sequence ?
Moderators: chulett, rschirm, roy
Surrogate Key using sequence ?
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.
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.
Well, write your max value a sequential file. Build a sequence job which has two an command activity stage. Pass the command
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.
Code: Select all
type your/fully/qualified/filename
Thats one way, i am sure there are other ways. Atleast this will get you started.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
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 ?
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 ?
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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.
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
is:What does the log say?
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'
I am sorry this is not scheduled problemWe now return you to your regularly scheduled problem
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
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.swades wrote:I am sorry this is not scheduled problemWe now return you to your regularly scheduled problem
Craig! Correct me if I botched up.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE