DSXchange

(I did search before posting...if I've missed it just tell me the text to search for...) Seq file --> xfm --> Seq file xfm has the constraint: NewKey NewKey is determined by RowProcCompareWithPrevValue. All is good except for the last record in the file. Does DS provide a variable for EOF condition?...

**Please remember that this is on a Windows platform** (Don't know if it makes any difference). Hi Barbara, Yes as Craig noted, the O/S makes a difference as to what commands you execute (I'm sure you know that :) ) I'll just point out that my "for" example in my earlier post is Windows s...

Hi Barbara, Can you post the exact command you're using to generate the file list? Also, you may want to type "help dir" and "help for" in a cmd window. In particular, I've sometimes used "for" instead of "dir" to generate a list of files. For example: for %i ...

Yes you can; in a trigger expression it's clearer to use OR conjunction. Matches was just easier to input Hardly the best criteria for making the decision regarding which one to use. :wink: OK...honestly...on this one, I'm not understanding why this isn't a good approach? I could code: MyActivity.$...

Yes you can; in a trigger expression it's clearer to use OR conjunction. Matches was just easier to input - choose the right Activity variable once, then paste in the above. If BASIC had the IN operator I would use it. shahidbakshi, @VM is the separator for the Matches function meaning "or&quo...

OK, this is what I've come up with. Say you have these sequence jobs: Seq_Parent Seq_Child Job where Job generates a warning. Options: 1. Set Seq_Child compilation options - untick "Log warnings after activities that finish with status other than OK". Pros: Seq_Child will finish with OK, s...

I'm looking for conditional code / stage execution based on the value of a parameter. Every active stage has three phases of execution: "startup", "per row" and "shutdown". So what I want is no "startup", "per row" and "shutdown" at all if ...

Hi, My job design looks like: DRS Stage --> xfm -- <Insert> --> DRS1 | | <Initialize> | V DRS2 DRS1 and DRS2 are the same table. DRS1's constraint is: JobParm = 0 DRS2's constraint is: JobParm = 2 i.e. they are mutually exclusive. The DRS2 stage does a "truncate then insert rows". There ar...

I've run into this issue as well... My sequence jobs are something like: SEQ_Main SEQ_Lev1 SEQ_Lev1.1 SEQ_Lev1.1.1 Job1 --> Job2 --> Job3 --> JobN I'd like to keep the triggers for the downstream sequences as "OK". However, Job2 generates a warning (database reject due to key constraints)....

Because, just like a sequence in - say - Oracle, what's stored in the sequence is the next available key value. Not the one you've just generated. Ok, my bad about what the next key in the hashed file should contain. I've changed my transform to: UtilityHashLookup("SDKSequences", %Key%, &...

There is IMO a minor issue with the out of the box KeyMgtGetNextValue and KeyMgtGetNextValueConcurrent routines. Here is an excerpt: * Read the named record from the file. * This obtains the lock (waiting if necessary). Readu NextVal From SeqFile, Arg1 Else NextVal = 1 End Ans = NextVal NextVal = Ne...

In Routines\SDK\KeyMgt, we have KeyMgtGetNextValue and KeyMgtGetNextValueConcurrent, but no KeyMgtGetCurrentValue (i.e. no increment). Is this as simple as creating a transform such as: UtilityHashLookup("SDKSequences",<desired key>,"") It needs to run concurrently, but is just a...

LIST.DICT DS_JOBS Note that this is not an SQL statement and so lacks a trailing semi-colon. Sorry to belabour this... OK, this is my output: $<50>DICT DS_JOBS 01:44:19pm 01 Apr 2009 Page 1 Type & Field......... Field. Field........ Conversion.. Column......... Output Depth & Name.............

Thanks Ray.

Since these tables are undocumented, can someone post a list of the tables they find most useful? I'll then search DSXchange for further hits, and how I might use these tables in my use of DS.

1. I've coded it such that NO arguments are required - whether that's good is another discussion, since that deviates from the requirements for Field: A) If pString is empty, return empty. If pString is null, return null B) If pDelimiter is empty, return pString. C) If pOccurence is empty, default t...