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.

How do I set a table.tbl to a variable for comparison

4 posts in General Discussion Last posting was on 2007-07-16 18:26:49.0Z
Tom Amon Posted on 2007-07-11 18:37:54.0Z
Sender: 5937.46952109.1804289383@sybase.com
From: Tom Amon
Newsgroups: sybase.public.impact
Subject: How do I set a table.tbl to a variable for comparison
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <46952382.5966.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 11 Jul 2007 11:37:54 -0700
X-Trace: forums-1-dub 1184179074 10.22.241.41 (11 Jul 2007 11:37:54 -0700)
X-Original-Trace: 11 Jul 2007 11:37:54 -0700, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.impact:2067
Article PK: 230153

Does anyone know how to set a table to a variable in custom
code so that I can do some comparisons? If provider is not
in table, I need to modify MSH-3 sending application by
appending "AUTO" to it from the OBR-16 Ordering Provider.


Christian Deschamps Posted on 2007-07-12 17:32:06.0Z
Sender: 72b0.4678177b.1804289383@sybase.com
From: Christian Deschamps
Newsgroups: sybase.public.impact
Subject: Re: How do I set a table.tbl to a variable for comparison
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <46966596.78d7.1681692777@sybase.com>
References: <46952382.5966.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Jul 2007 10:32:06 -0700
X-Trace: forums-1-dub 1184261526 10.22.241.41 (12 Jul 2007 10:32:06 -0700)
X-Original-Trace: 12 Jul 2007 10:32:06 -0700, 10.22.241.41
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.impact:2068
Article PK: 230147

1) add a table row that is a default entry. This entry
contains no value for the input and it has a literal value
for the output such as "?", i.e. [][?][default]
2) Set a datalink to the input field OBR-16.
3) select the input field MSH-3 in the rule component.
4) call the translation table in the pre-filters.
5) and next, call an ODL filter that checks the result of
the translation. If the blob (*pb) value is "?" then assign
the datalink of the OBR-16 to the blob and append "AUTO" to
the blob.

> Does anyone know how to set a table to a variable in
> custom code so that I can do some comparisons? If
> provider is not in table, I need to modify MSH-3 sending
> application by appending "AUTO" to it from the OBR-16
> Ordering Provider.


chris Posted on 2007-07-13 03:04:11.0Z
Sender: 1de3.465ba54e.1804289383@sybase.com
From: Chris
Newsgroups: sybase.public.impact
Subject: Re: How do I set a table.tbl to a variable for comparison
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4696ebab.7af.1681692777@sybase.com>
References: <46966596.78d7.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 12 Jul 2007 20:04:11 -0700
X-Trace: forums-1-dub 1184295851 10.22.241.41 (12 Jul 2007 20:04:11 -0700)
X-Original-Trace: 12 Jul 2007 20:04:11 -0700, 10.22.241.41
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.impact:2070
Article PK: 230150

If the table was created so it had two columns
one you look up which would contain the "providers"
- and the other you return
the "return"s should be all blank

Except the default value would be set to output "Auto"

than just run the table as a filter

this should return the blanks for any entry in the table
and "Auto" if it isn't
--
something like:
[133121][]
[112121][]
[][Auto][default]

> 1) add a table row that is a default entry. This entry
> contains no value for the input and it has a literal value
> for the output such as "?", i.e. [][?][default]
> 2) Set a datalink to the input field OBR-16.
> 3) select the input field MSH-3 in the rule component.
> 4) call the translation table in the pre-filters.
> 5) and next, call an ODL filter that checks the result of
> the translation. If the blob (*pb) value is "?" then
> assign the datalink of the OBR-16 to the blob and append
> "AUTO" to the blob.
>
> > Does anyone know how to set a table to a variable in
> > custom code so that I can do some comparisons? If
> > provider is not in table, I need to modify MSH-3 sending
> > application by appending "AUTO" to it from the OBR-16
> > Ordering Provider.


Tom Amon Posted on 2007-07-16 18:26:49.0Z
Sender: 5937.46952109.1804289383@sybase.com
From: Tom Amon
Newsgroups: sybase.public.impact
Subject: Re: How do I set a table.tbl to a variable for comparison
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <469bb869.1629.1681692777@sybase.com>
References: <4696ebab.7af.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Jul 2007 11:26:49 -0700
X-Trace: forums-1-dub 1184610409 10.22.241.41 (16 Jul 2007 11:26:49 -0700)
X-Original-Trace: 16 Jul 2007 11:26:49 -0700, 10.22.241.41
Lines: 41
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.impact:2076
Article PK: 230161

Thank you both for the help!!! I had called SYBASE support
who recommended an additional solution:
Add two filters with qualifications to "MATCH" table.tbl
and another for No-Match on the datalink to OBR-16 and pass
accordingly which works.

Thanks again for your valuable insight!!!

> If the table was created so it had two columns
> one you look up which would contain the "providers"
> - and the other you return
> the "return"s should be all blank
>
> Except the default value would be set to output "Auto"
>
> than just run the table as a filter
>
> this should return the blanks for any entry in the table
> and "Auto" if it isn't
> --
> something like:
> [133121][]
> [112121][]
> [][Auto][default]
>
>
> > 1) add a table row that is a default entry. This entry
> > contains no value for the input and it has a literal
> > value for the output such as "?", i.e. [][?][default]
> > 2) Set a datalink to the input field OBR-16.
> > 3) select the input field MSH-3 in the rule component.
> > 4) call the translation table in the pre-filters.
> > 5) and next, call an ODL filter that checks the result
> > of the translation. If the blob (*pb) value is "?" then
> > assign the datalink of the OBR-16 to the blob and append
> > "AUTO" to the blob.
> >
> > > Does anyone know how to set a table to a variable in
> > > custom code so that I can do some comparisons? If
> > > provider is not in table, I need to modify MSH-3
> > > sending application by appending "AUTO" to it from the
> > > OBR-16 Ordering Provider.