DSXchange

chulett

He already stated the returned value was "field mark delimited". A Field Mark is one of the many System Variables you should be familiar with.

chulett

And the request to shutdown your antivirus for an install is pretty standard Windows stuff nowadays. Not really a hard-and-fast requirement, more of a strong suggestion in case it interferes. It usually doesn't.

chulett

I'd rather see if you can work it out on your own with some help rather than just provide a solution... teach a man to fish and all that. Did you look to see what paste does? Have you tried to put the requirement into words? A lot of times, simply spelling out what needs to be done can lead you to t...

chulett

Yes, completely compatible.

chulett

What was your answer?

chulett

we cannot go for surrogate key stage as we need to maitain the referntial integrity of the keys. moreover we will use these keys in other jobs so as we cannot lose the values during runtime Sorry but I'm afraid I don't understand either sentence in this context. Does the first one refer to the ques...

chulett

Are you looking for a Server or a PX solution? You've posted in the PX forum but marked your post as Server, hence the question.

chulett

Start by posting your question in the correct forum.

chulett

Here, let me take a wild stab at that.

Code: Select all

$INCLUDE DSINCLUDE JOBCONTROL.H 
vLen=len(Arg1) 
abc=''
For Arg2 = vLen To 1 Step -1 
If Arg1[Arg2,1]="" or Arg1[Arg2,1]=" " 
then 
end 
else 
abc=Seq(Arg1[Arg2,1]):abc 
end  
Next Arg2 
Ans=abc

chulett

The error is pretty self-explanatory. You are referencing a variable that has yet to be defined. Solution? Initialize it properly.

chulett

DSguru2B wrote:
chulett wrote:I thought (from other posts here) that DB2 wanted dates in internal format.
Thats true for server. For px it has to be a date.

Ah... thanks.

chulett

Repost your script. You have a problem at line 11.

chulett

There's no coversion for that. If you have to use the value from the SDK hashed file, you'll need to use the BASIC Transformer or a Server Shared Container. Are you actively sharing this key source with Server jobs? If not, why not switch to a parallel source like the Surrogate Key Generator stage?

chulett

Always been a requirement, as far as I recall. [shrug]

chulett

I would verify that your telnet session is using the correct characterset.

Search found 42189 matches