Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

ODL code for table lookup

3 posts in General Discussion Last posting was on 2008-02-05 07:29:16.0Z
Mike Posted on 2007-12-04 20:18:27.0Z
Subject: ODL code for table lookup
From: Mike <mike.rhoads@samcstl.org>
Organization: St. Anthony's Medical Center
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Newsgroups: sybase.public.impact
Content-Transfer-Encoding: 7bit
Message-ID: <op.t2tun2j9axxnk6@80y9b81.samcstl.org>
User-Agent: Opera Mail/9.24 (Win32)
NNTP-Posting-Host: pop3.samcstl.com
X-Original-NNTP-Posting-Host: pop3.samcstl.com
Date: 4 Dec 2007 12:18:27 -0800
X-Trace: forums-1-dub 1196799507 70.251.218.147 (4 Dec 2007 12:18:27 -0800)
X-Original-Trace: 4 Dec 2007 12:18:27 -0800, pop3.samcstl.com
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.impact:2102
Article PK: 230184

Is it possible to write ODL code to do a table lookup similar to the
default table code that you get when you create a new qualification? I
ask because I need to do a qualification based on two tables failing.

Thanks,
Mike


Terry Moore Posted on 2007-12-06 20:08:55.0Z
From: "Terry Moore" <tmoore@lpch.org>
Newsgroups: sybase.public.impact
References: <op.t2tun2j9axxnk6@80y9b81.samcstl.org>
Subject: Re: ODL code for table lookup
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1914
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1914
NNTP-Posting-Host: 209.11.191.1
X-Original-NNTP-Posting-Host: 209.11.191.1
Message-ID: <475856d7$1@forums-1-dub>
Date: 6 Dec 2007 12:08:55 -0800
X-Trace: forums-1-dub 1196971735 209.11.191.1 (6 Dec 2007 12:08:55 -0800)
X-Original-Trace: 6 Dec 2007 12:08:55 -0800, 209.11.191.1
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.impact:2103
Article PK: 230183

Mike,

In Impact 4.1, the following example worked:

blob b;
char m;
string valuetolookup;

b = "abc"; // Table is in file "abc.tbl".
m = 1;
valuetolookup = "123"; // value to be looked up in table abc.tbl.
rv = tblconv( &b, m, valuetolookup );

rv==1 if lookup is successful, in which case b contains the value found in
the table. The value to look up must be in the table's first column, and
the value to be retrieved must be in the second column.

I haven't tried it in Impact v5.

- Terry Moore
tmoore@lpch.org
650-736-4089

"Mike" <mike.rhoads@samcstl.org> wrote in message
news:op.t2tun2j9axxnk6@80y9b81.samcstl.org...
> Is it possible to write ODL code to do a table lookup similar to the
> default table code that you get when you create a new qualification? I
> ask because I need to do a qualification based on two tables failing.
>
> Thanks,
> Mike


Vinay Posted on 2008-02-05 07:29:16.0Z
From: "Vinay" <isvinay@yahoo.co.in>
Newsgroups: sybase.public.impact
Subject: Re: ODL code for table lookup
References: <op.t2tun2j9axxnk6@80y9b81.samcstl.org> <475856d7$1@forums-1-dub>
X-Newsreader: newsgroupstats.hk
X-HTTP-Posting-Host: 164.164.45.250
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47a8104c@forums-1-dub>
Date: 4 Feb 2008 23:29:16 -0800
X-Trace: forums-1-dub 1202196556 10.22.241.152 (4 Feb 2008 23:29:16 -0800)
X-Original-Trace: 4 Feb 2008 23:29:16 -0800, vip152.sybase.com
Lines: 38
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.impact:2109
Article PK: 230189

Can you explain me how to lookup values in table using ODL function.


Thanks,
Vinay
--
Free News Reader
http://put.hk
http://put.hk/reader/forums.sybase.com/sybase.public.impact.html

Terry Moore <tmoore@lpch.org> wrote:
> Mike,
> In Impact 4.1, the following example worked:
> blob b;
> char m;
> string valuetolookup;
> b = "abc"; // Table is in file "abc.tbl".
> m = 1;
> valuetolookup = "123"; // value to be looked up in table abc.tbl.
> rv = tblconv( &b, m, valuetolookup );
> rv==1 if lookup is successful, in which case b contains the value found in
> the table. The value to look up must be in the table's first column, and
> the value to be retrieved must be in the second column.
> I haven't tried it in Impact v5.
> - Terry Moore
> tmoore@lpch.org
> 650-736-4089
> "Mike" <mike.rhoads@samcstl.org> wrote in message
> news:op.t2tun2j9axxnk6@80y9b81.samcstl.org...
> > Is it possible to write ODL code to do a table lookup similar to the
> > default table code that you get when you create a new qualification? I
> > ask because I need to do a qualification based on two tables failing.
> >
> > Thanks,
> > Mike