T24: Interfacing with SWIFT

[Nodirbek Ubaydullaev]

I need to interface T24 with SWIFT via CASmf as transport. This is on
AIX and jBase 5 which are 64 bit compaint. Missing part is libcus.a
library 64 bit complaint. Please advise how can I get libcus.a library
that is 64 bit complaint?

Thanks a lot in advance,

Nodirbek

[Treg Taylor]

All-

TASK: Jcopy records from one file to another.

ISSUE: I have a saved select list, I would like to select against a file where attrib 4 or 5 equals the values from the saved select list. Then copy the records to another file.

If I were in sql, I would use an INNER JOIN or a WHERE - IN clause.

Thanks in advance,

Treg
========
System: Win2K CUBS 5.0 i386
OS Release: Win 2000 Build 2195 Service Pack 4
RELEASE Information: Major 3.4 , Minor 2 , Patch 05


Notice: This electronic transmission and its attachments are confidential and protected by applicable state and/or federal law. Any use, reading, dissemination, distribution, copying or storage of this information by anyone other than the intended recipient is strictly prohibited. If you are not the intended recipient, please immediately notify the sender by return email or telephone and delete this message and its attachments from your system.

[Jim Idle]

You need to be more specific.

When you say attribute 4 or attribute 5 equals the values, do you mean that every value in attribute 4 or attribute 5 should equal each element of the stored list (in order?), or that all values of attribute 4 or attribute 5 should be found anywhere in the stored list, or that any value of attribute 4 or attribute 5 is equal to any element of the stored list, or that any value of attribute 4 or attribute 5 correlates with a value at the same position in the stored list. Are attribute 4 and 5 even multivalued (though strictly speaking, they are multivalued even if they have no elements)?

Depending on what you mean (and with the CUBS software, it could be any of those ;-), you could generate a jQL statement:

SELECT FILE WITH ATTR4 = "v1" "v2" "v3" ... OR WITH ATTR5 = "v1" "v2" "v3" ....

Then use the resulting list to drive JCOPY. But the semantics of the select may not be what you are trying for.

To be honest, it sounds like you are going about whatever it is you want to do, the wrong way. What you are trying to do will be very inefficient. Why don't you step back and say what you are trying to do, where this magic list is generated from and why it is generating a list.

It would be very much more efficient to write a small program to do this and the program would take very little time to write. If this is going to be an application task that happens a lot, then you want a program that does the whole task and not have something else produce a list, then pick it up.

Jim
PS: Windows 2000? ;-)

> --
> 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

[Treg Taylor]

Jim:

I know, I know, Win2K.... arrggghhhh; thems the breaks.

Well this is a mute point now, as the data extract requirements have changed.

FYI: I was looking at identifying rows in one file where attrib 4.1.1 or attrib 5.1.1 was listed in a file of 61K rows.

Thanks for your help

Treg

[Daniel Klein]

SELECT file1 *A4 *A5
SAVE-LIST mylist
GET-LIST mylist
SELECT file2

If the data is multi-valued or sub-valued then construct a dictionary
items like this:

ID: A4
001 I
002 @RECORD<4,1,1>
003
004
005 10L

ID: A5
001 I
002 @RECORD<5,1,1>
003
004
005 10L

then change the first statement to:

SELECT file1 A4 A5

Dan

[JOSE L MARTINEZ-AVIAL]

I think that what Treg is asking is how to do something like the following:

  SELECT FILE1
  SAVE-LIST MYLIST

  SELECT FILE2 WITH ATTR4 EQ MYLIST

So, the question is how to use a selection to select records in other file not by id, but by another attribute. I'd like to know if it's possible to, it would make my life easier.

Regards

Jose

2009/12/11 Daniel Klein <daniel...@gmail.com>

[Daniel Klein]

In that case create this dictionary in FILE2:

ID: ATTR4
001 A
002 4
003
004
005
006
007
008 TFILE1;X;;0
009 L
010 10

[ or create a similar I-type using the TRANS() function ]

then

SELECT FILE2 WITH ATTR4

That should do it!

Dan

[Kevin Powick]

On Dec 11, 7:34 pm, Daniel Klein <danielklei...@gmail.com> wrote:
> In that case create this dictionary in FILE2:
>
> ID: ATTR4
> 001 A
> 002 4
> 003
> 004
> 005
> 006
> 007
> 008 TFILE1;X;;0
> 009 L
> 010 10
>
> [ or create a similar I-type using the TRANS() function ]
>
> then
>
> SELECT FILE2 WITH ATTR4
>
> That should do it!

Except that you've not included the concept/requirement to SELECT
FILE2 against only a subset of items from FILE1.

Ex. SELECT FILE1 WITH CRITERIA = 'XYZ'
N ITEMS SELECTED
SELECT FILE2 WITH ATTR4 <-- Will not work

Probably the only way to do it is to add additional Translate dict
items to FILE2 so that the FILE1 criteria can be included in a
straight SELECT against FILE2

Ex. SELECT FILE2 WITH ATTR4 AND WITH F1.CRITERIA = 'XYZ'

--
Kevin Powick