how to store a value into a parameter from sql query.

laxmi_etl · Post by **laxmi_etl** » Mon Dec 11, 2006 3:18 pm

I need to store the result from oracle enterprise stage which always returns single value into a parameter. I have to use this parameter in other jobs.
Any help.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 11, 2006 3:33 pm

Run in a separate job, store the result in a file or in the job's user status area. Pick that up in the job sequence and feed its value to your job parameter in the Job activity.

laxmi_etl · Post by **laxmi_etl** » Mon Dec 11, 2006 4:01 pm

ray.wurlod wrote:Run in a separate job, store the result in a file or in the job's user status area. Pick that up in the job sequence and feed its value to your job parameter in the Job activity.

How to pick up the result from the file and pass it to next job in the sequence?. Do we need to use any special activity stage to store result from file created?.

us1aslam1us · Post by **us1aslam1us** » Mon Dec 11, 2006 4:11 pm

Hi

Create a parm file and when you schedule your job thru script call this parm file with other parameters in the dsjob command.

A good discussion is available in this forum and a script is also available. Either do a search on DSGuru2B or Parm file.

Thanks
Sam

laxmi_etl · Post by **laxmi_etl** » Mon Dec 11, 2006 4:39 pm

ray.wurlod wrote:Run in a separate job, store the result in a file or in the job's user status area. Pick that up in the job sequence and feed its value to your job parameter in the Job activity.

Ray,
Can you tell me how to store the value in user status area?. What stage to use for that?. We are using parallel edition.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 11, 2006 5:54 pm

Use a BASIC Transformer stage (the overhead for one row can be ignored) and use the DSSetUserStatus() function in a constraint or derivation expression. Search the forum for examples.

laxmi_etl · Post by **laxmi_etl** » Mon Dec 11, 2006 6:18 pm

ray.wurlod wrote:Use a BASIC Transformer stage (the overhead for one row can be ignored) and use the DSSetUserStatus() function in a constraint or derivation expression. Search the forum for examples.

We do not have BASIC Transformer stage . We have regular Transformer stage and it is not accepting any DSSetUserStatus() function. Is there anyway to do this with regular Transformer stage ?.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 11, 2006 7:12 pm

You DO have BASIC Transformer stage.

It's in the Stage Types branch of your Repository.