Generate SQL is a required link property for Link DSLink1

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ketfos
Participant
Posts: 562
Joined: Mon May 03, 2004 8:58 pm
Location: san francisco
Contact:

Generate SQL is a required link property for Link DSLink1

Post by ketfos »

Hi
I imported a job from development enviornment to test enviorment using istool import and export command.

When I try to read the source (Oracle table), I get a message as

Generate SQL is a required link property for Link DSLink1

My sql is custom sql and works fine in development enviornment
I am using the same database as used in development enviornment but gives me above error in test enviornment.

Ketfos
ketfos
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

You might want to try right-clicking on the stage and selecting 'Grid style' to verify all of the settings. Do this in both dev and test to compare.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The error message suggests that the user-defined SQL is actually missing from the stage (from the link).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply