DSXchange

Hi Ken,
May I get a copy as well. Thanks.

Thank you Ken for your patience.

Gosub is used to branch to a section of code and return at the point of branching. Goto is an unconditional branch without return. In your example, the logic Gosub subA branched to label subA, then the Return statement send the pointer back to the the Gosub SubA statement. It then did a branch at G...

Hi, I'm new to DS Basic. I'm writing a Transform Function. Here's the pseudo code: * Main GoSub subA GoSub subB GoTo Finish * Subroutine A subA: Data = 0 ;* I intentionally make it fail If (Data = 0) Then GoTo Finish End Return (Data) * Subroutine B subB Print "I am B" Data = 3 Return (Dat...

I got my answer by searching the forum. Sorry for not doing that first.

I think my problem was not providing invocation id when I ran with 'dsjob -run...'. How do you pass in invocation id as a param? What's the param variable for INVOCATION ID? Thank you.

Thank you for your relyies. I have a seq --> xfm -->seq job that is multiple instance enabled. When I tried to run 3 instances concurrently with 'dsjob -run -param...', the first instance ran OK. But the others returned with 'Status code = -2 DSJE_BADSTATE'. What did I do wrong?
Thank you.

Can you run a multiple instance enabled job on a single CPU (Windows) box? Thanks.

To All!

Thank you Ken for your quick and detailed reply.

Happy Holidays to all. I'm trying to educate myself in Data warehouse arena. Can someone suggest some good books/training courses/web sites, please? I'm considering buying "The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)" by Ralph Kimball and Margy R...