DSGetLinkMetaData

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
sathishmca
Participant
Posts: 43
Joined: Mon Mar 03, 2008 10:58 pm
Location: Chennai

DSGetLinkMetaData

Post by sathishmca »

for i = 1 to StageCount
for j =1 to LinkCount
Call DSGetLinkMetaData(Result,JobName,stgtempname,stglinkdelimt)
SubStringCount2= DCOUNT(Result<9>,@VM)
For k = 1 to SubStringCount1
WriteSeq "Columns:":Result<1,k> :"the deriavtion is:":Result<9,k> To FileVar Then f=@True
Next k
Next j
Next i


For the first stage, it fetches column names and derivation.
But for the second stage, its fetching only the column names but not its derivation.
Sathish Bhojan
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

:? Seems remarkably similar to this post:

viewtopic.php?t=125402
-craig

"You can never have too many knives" -- Logan Nine Fingers
sathishmca
Participant
Posts: 43
Joined: Mon Mar 03, 2008 10:58 pm
Location: Chennai

DSGetLinkMetaData

Post by sathishmca »

Yes, the same problem but there is no proper solution. We tried so many times.
Sathish Bhojan
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Problem is, when you start a new post, the merry-go-round gets to start all over again. Best to stick to the original post and keep working at the problem there.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply