T24: Problem witn OFS Records delimiter

[firas]

Hello
I'm using R09, jbase 5.0 on AIX,
I am yengui Firas, a new T24 developer
I want to use OFS ENQUIERY.SELECT , in the fields’ value there are
comma (in STANDARD.SELECTION for example: SUNR(xxx,xxxx) ...etc) , or
the comma is the OFS record separator. It's possible to change the
comma delimiter in OFS or there are other solutions for this?

Can anyone help how to resolve this?
Thanks in advance

[Ram shankar]

Hi,

Replace with ? (question mark) wherever , comma is used in the field values of the OFS message.

Thanks

Many Regards, Ram

--
Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines

IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24

To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

[Jane]

 

you can use question marks(?) to replace commas(,) in the OFS request message

cheers

[Joy_base]

ENQUIRY.SELECT are mainly used for querying t24, hence, I don't see
how "," (commas) will pose a challenge.
Can you send a sample of the OFS string you want to pass?
A sample OFS ENQUIRY.SELECT message from the tSS goes thus;

jbase --> tSS
ENQUIRY.SELECT,,INPUTT/123456,CURRENCY-LIST

[VK]

Hi,
are you trying to get some data via ENQUIRY.SELECT and you wish to
replace commas that divide the output? E.g.:

%COMPANY//1,,@ID::@ID/COMPANY.NAME::COMPANY.NAME," XY0010001"
"COMPANY 1 "," XY0010002" "COMPANY 2 ",

To:


%COMPANY//1,,@ID::@ID/COMPANY.NAME::COMPANY.NAME," XY0010001"
"COMPANY 1 "~" XY0010002" "COMPANY 2 "~

On Nov 20, 6:20 am, Ram shankar <ram.r.shan...@gmail.com> wrote:
> Hi,
>
> Replace with ? (question mark) wherever , comma is used in the field values
> of the OFS message.
>
> Thanks
>
> Many Regards, Ram
>

[Beni gilbert]

Hi,

 

   In R07 the (?) replaces (,) operator. But in G14 the (?) will not replace the (,) operator. For R07 (") operator is not recognised in OFS mesage.

 

The following are the pblms in OFS message,

G14 - comma operator

R07 - double quotes operator 

 

Regards,

Beni S. Gilbert 

[firas]

Hi,

My problem with OFS is not in the request but in the response data

if i receive data like this :

%COMPANY//1,,@ID::@ID/COMPANY.NAME::COMPANY.NAME," XY0010001"
"COMPANY 1 "," XY0010002" "COMPANY 2 ",

no problem , but i have data like this

%COMPANY//1,,@ID::@ID/COMPANY.NAME::COMPANY.NAME," XY0010001"
"COMPANY 1 "," XY0010002" "var<1,2>",

On 25 nov, 05:31, Beni gilbert <dreamsb...@gmail.com> wrote:
> Hi,
>
>    In R07 the (?) replaces (,) operator. But in G14 the (?) will not replace
> the (,) operator. For R07 (") operator is not recognised in OFS mesage.
>
> The following are the pblms in OFS message,
> G14 - comma operator
> R07 - double quotes operator
>
> Regards,
> Beni S. Gilbert
>
>
>
> On Mon, Nov 23, 2009 at 6:13 PM, VK <kzm...@yahoo.com> wrote:
> > Hi,
> > are you trying to get some data via ENQUIRY.SELECT and you wish to
> > replace commas that divide the output? E.g.:
>

> > %COMPANY//1,,@ID::@ID/COMPANY.NAME::COMPANY.NAME <http://company.name/>,"

> >  XY0010001"
> > "COMPANY 1        ","  XY0010002"  "COMPANY 2    ",
>
> > To:
>

> > %COMPANY//1,,@ID::@ID/COMPANY.NAME::COMPANY.NAME <http://company.name/>,"

[firas]

Hi,

Thik you for your response,

My problem is not in the request but in the response data ,

if i receive data like this : %COMPANY//1,,@ID::@ID/

COMPANY.NAME::COMPANY.NAME," XY0010001"
"COMPANY 1 "," XY0010002" "COMPANY 2 ",

no problem but i have response data like this :

%COMPANY//1,,@ID::@ID/COMPANY.NAME::COMPANY.NAME," XY0010001"
"COMPANY 1 "," XY0010002" "SUBR("COMPANY","VAR2")" "
<1,1> ",
there are many comma in addition to the delimiter

I hope tha my problem is most clear now

Yengui FIRAS

On 25 nov, 05:31, Beni gilbert <dreamsb...@gmail.com> wrote:

> Hi,
>
>    In R07 the (?) replaces (,) operator. But in G14 the (?) will not replace
> the (,) operator. For R07 (") operator is not recognised in OFS mesage.
>
> The following are the pblms in OFS message,
> G14 - comma operator
> R07 - double quotes operator
>
> Regards,
> Beni S. Gilbert
>
>
>
> On Mon, Nov 23, 2009 at 6:13 PM, VK <kzm...@yahoo.com> wrote:
> > Hi,
> > are you trying to get some data via ENQUIRY.SELECT and you wish to
> > replace commas that divide the output? E.g.:
>

> > %COMPANY//1,,@ID::@ID/COMPANY.NAME::COMPANY.NAME <http://company.name/>,"

> >  XY0010001"
> > "COMPANY 1        ","  XY0010002"  "COMPANY 2    ",
>
> > To:
>

> > %COMPANY//1,,@ID::@ID/COMPANY.NAME::COMPANY.NAME <http://company.name/>,"

[VK]

Hi,
yes as I've suspected the software you're using to parse the response
fails to tell one comma from another :)

What about replacing commas in data to something else? You can do it
in OUT.MSG.RTN