Just for Teej

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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Just for Teej

Post by ray.wurlod »

Here's Teej's special server routine. Use the test grid!

Code: Select all

FUNCTION Teej(Arg1)
* Arg1 is ignored.
Cmd = "SELECT @ID FROM VOC WHERE TYPE = 'K' AND OP.CODE = 16 FIRST 1 COL.SUP COUNT.SUP;"
Call DSExecute("UV", Cmd, Output, Code)
Ans = Field(Trim(Trim(Output,@FM,"B")),".",1,1):Ereplace(Field(Cmd," ",13,1),"IR","A")
RETURN(Ans)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

:lol:
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Teej
Participant
Posts: 677
Joined: Fri Aug 08, 2003 9:26 am
Location: USA

Re: Just for Teej

Post by Teej »

Code: Select all

FUNCTION Teej(Arg1)
* Arg1 is ignored.
Cmd = "SELECT @ID FROM VOC WHERE TYPE = 'K' AND OP.CODE = 16 FIRST 1 COL.SUP COUNT.SUP;"
Call DSExecute("UV", Cmd, Output, Code)
Ans = Field(Trim(Output,@FM,"B"),".",1,1):Ereplace(Field(Cmd," ",13,1),"IR","A"):"? ":Cmd[3,1]:Cmd[68,1]:Cmd[74,1]:Cmd[63,1]:Cmd[22,1]:"!":Cmd[31,2]:Cmd[10,1]
RETURN(Ans)
There. I fixed it for you.

:lol:

Thanks. :)

-T.J.
Developer of DataStage Parallel Engine (Orchestrate).
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

You clowns have too much time on your hands.

Kim.
Mamu Kim
stotman
Premium Member
Premium Member
Posts: 14
Joined: Mon Nov 04, 2002 5:00 pm
Location: UK
Contact:

Post by stotman »

TeeJ wins the prize for the biggest geek ever - he's the only person I know who upon meeting you adds your IM address into his phone and can instantly IM you 8)

He even out geeked frobnoid 8)

Steve
AndrewWebbUK
Participant
Posts: 17
Joined: Sun Sep 14, 2003 6:14 am

Post by AndrewWebbUK »

stotman wrote:TeeJ wins the prize for the biggest geek ever - he's the only person I know who upon meeting you adds your IM address into his phone and can instantly IM you 8)

He even out geeked frobnoid 8)

Steve
steve, your only jealous! ;)
Andrew Webb
Principal SE Ascential UK

www.ascential.com
spracht
Participant
Posts: 105
Joined: Tue Apr 15, 2003 11:30 pm
Location: Germany

Post by spracht »

What's going on here :?
Kind Regards
Stephan
Teej
Participant
Posts: 677
Joined: Fri Aug 08, 2003 9:26 am
Location: USA

Post by Teej »

stotman wrote:TeeJ wins the prize for the biggest geek ever - he's the only person I know who upon meeting you adds your IM address into his phone and can instantly IM you 8)

He even out geeked frobnoid 8)
Not for much longer. Frobnoid is eagerly searching for a toy like mine, if not better.

For others who are clueless -- from TMobile, they provide Sidekick which is made by Danger.com. Sidekick is currently capable of AIM, Web, E-mail, phone, text messaging, and a couple other PDA stuff (calendar and stuff). The new upgrade coming this month will add SSH/Telnet capability, along with other enhancements.

Only problem: It doesn't support Java yet, so Frobnoid is sad.

:lol:

-T.J.

P.S. For those who also doesn't know -- I used to have a sig that was hoping that DataStage would make breakfast for me. Now that we upgraded to DSXchange, my SIG is upgraded to lunch! Just you wait ... once ADN gets up... DINNER!

:-P
Developer of DataStage Parallel Engine (Orchestrate).
Post Reply