Re: Hung processes

2023-03-09 Thread Peter Falson
You could stop and restart your jbase_agent with logging (to a file) and try to find the request(s). This may be needles in haystacks if you have a lot going on.If when you find the culprit you could run a separate jbase_agent in foreground (using a different port) and even potentially debug if you have a version that supports that (and assuming it’s a REST type client app).jbase_agent -d -JD {remaining options….}With the above you can also do remote debugging with -JRHaving said that it might not be Sent from my iPhoneOn Mar 9, 2023, at 9:01 AM, troyd1  wrote:Just to confirm, this is still happening on 5.8/6.3Typically we will see them and they go away quickly there are currently 6 hung.  Is there a way to find out what initiated them?Here is our top:   2853 dm_jbas+  20   0 4123772    476    460 R  94.7   0.0   4284:05 jbase_a+  54208 dm_jbas+  20   0 4192380    740    720 R  89.5   0.0   4206:28 jbase_a+1034016 dm_jbas+  20   0 4127500   1620   1604 R  89.5   0.0   2849:39 jbase_a+3377532 dm_jbas+  20   0 4119560   1.4g 616668 R  89.5   9.1  16:46.51 jbase_a+4139747 dm_jbas+  20   0 4148796    504    488 R  89.5   0.0   4297:11 jbase_a+3292549 dm_jbas+  20   0 4121908 995216 133128 R  84.2   6.1 105:44.34 jbase_a+On Thursday, January 26, 2023 at 4:15:44 PM UTC-6 Peter Falson wrote:In a nut shell, some (usually network based) request is coming into your jbase_agent listener which results in a child process (worker thread). There is/was a bug with jbase_agent worker threads not being cleaned up under certain circumstances. I was under the impression this was fixed in 5.8.7.Sent from my iPhoneOn Jan 26, 2023, at 12:49 PM, troyd1 <tr...@mninter.net> wrote:we are on jbase 5.8/6.3, rhel 8.3.  We occasionally have jbase_agent processes that are hung when doing top in linux.  Sometimes several a day.  They will be using 100% cpu.  They could possibly be in a loop, but don't know.  The are not tied to any port in a listu.  How can I determine what those processes are doing?  Is there like a where command for process instead of port?



-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
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

--- 
You received this message because you are subscribed to the Google Groups "jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbase+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/eaeb3a8f-822e-41a2-8513-af324813aa64n%40googlegroups.com.




-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
To post, send email to jBASE@googlegroups.com
To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

--- 
You received this message because you are subscribed to the Google Groups "jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/e19abfe1-609f-4cd2-83a9-beeff5be8eddn%40googlegroups.com.




-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
To post, send email to jBASE@googlegroups.com
To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

--- 
You received this message because you are subscribed to the Google Groups "jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/AD3B9B6C-6FEC-4B3B-89B8-68F80402E567%40gmail.com.


Re: Hung processes

2023-01-26 Thread Peter Falson
In a nut shell, some (usually network based) request is coming into your jbase_agent listener which results in a child process (worker thread). There is/was a bug with jbase_agent worker threads not being cleaned up under certain circumstances. I was under the impression this was fixed in 5.8.7.Sent from my iPhoneOn Jan 26, 2023, at 12:49 PM, troyd1  wrote:we are on jbase 5.8/6.3, rhel 8.3.  We occasionally have jbase_agent processes that are hung when doing top in linux.  Sometimes several a day.  They will be using 100% cpu.  They could possibly be in a loop, but don't know.  The are not tied to any port in a listu.  How can I determine what those processes are doing?  Is there like a where command for process instead of port?



-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
To post, send email to jBASE@googlegroups.com
To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

--- 
You received this message because you are subscribed to the Google Groups "jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/eaeb3a8f-822e-41a2-8513-af324813aa64n%40googlegroups.com.




-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
To post, send email to jBASE@googlegroups.com
To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en

--- 
You received this message because you are subscribed to the Google Groups "jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/AA73CC3C-1DA6-4876-B7C9-A0FAC3BB0B63%40gmail.com.


Re: Count records using Dictionary

2021-12-23 Thread Peter Falson
Doug,

I suspect your problem may be either an MD or DICT entry of “1” (ie. the key) 
which was an issue early 5.8 but is now ignored when an itype references an 
integer. So you could also quote the number but more importantly this is a 
heads up that you may want to consider upgrading to 5.8.5 (due out this or next 
week).

Sent from my iPhone

> On Dec 23, 2021, at 8:05 AM, dfleetham_HMA  
> wrote:
> 
> 
> Hi Peter,
> 
> config-strings output is:
> JBCRELEASEDIR  : D:\jBase\5.8.2
> JBCGLOBALDIR   : D:\jBase\global
> JBCEMULATE : jbase
> Emulation file : D:\jBase\global\config\Config_EMULATE
> 
> compiler_options ""
> dates_upper_case true
> enter_keeps_common_data  false
> error_numbers_are_single_attribute   false
> itype_trans_replace_delimfalse
> itype_unquoted_numeric_literal   true
> jbase_field  true
> list_keystrue
> lock_strategythread
> named_common null
> old_jql_output_style false
> readv0   key
> reality_videotrue
> treat_with_as_or_withtrue
> unnamed_common   unassigned
> use_sql_syntax_for_selectfalse
> 
> Thanks,
> 
> Doug.
> 
>> On Wednesday, 22 December 2021 at 13:29:17 UTC-8 pfalson wrote:
>> Doug,
>> 
>> This may have been patched but can you post the output of
>> 
>> config-strings 
>> 
>> 
>> Sent from my iPhone
>> 
 On Dec 22, 2021, at 11:25 AM, dfleetham_HMA  
 wrote:
 
>>> Hi All,
>> 
>>> 
>>> 
>>> We've recently (ish) moved from to 5.8.2 from I have no idea what (4.#?).
>>> 
>>> In the previous iteration I had a dictionary item that I added to most 
>>> files and it was labelled 'CNT'. It was a fixed value of 1 and looked like:
>>> 
>>> CNT
>>> 001 I
>>> 002 1
>>> 003 MR0,
>>> 004 CNT
>>> 005 8R
>>> 
>>> And it was useful for counting records in a report; if I ran a query like:
>>> 
>>> SORT D:\D_Shared\This Client\ThatCampaign\CUST_GIFT_DATA BY 28 BREAK-ON 28 
>>> TOTAL 22 TOTAL CNT (ID
>>> 
>>> I would get something like:
>>> 
>>> Last Gift.Gift AmtCNT.
>>> Year  
>>> 
>>>   2014   $75.00   3
>>>   2015   $85.00   4
>>>   2016   $95.00   4
>>>   2017   $65.00   2
>>>   2018   $80.00   3
>>>   2019   $90.00   3
>>>    
>>> ***  $490.00 19
>>> 
>>> Having moved to 5.8.2, the CNT dictionary item doesn't seem to work and 
>>> running the same query, I get:
>>> 
>>> Last Gift.Gift AmtCNT.
>>> Year  
>>> 
>>>   2014   $75.00   0
>>>   2015   $85.00   0
>>>   2016   $95.00   0
>>>   2017   $65.00   0
>>>   2018   $80.00   0
>>>   2019   $90.00   0
>>>    
>>> ***  $490.00  0
>>> 
>>> There's probably a very simple solution; I just haven't found it. Is there 
>>> a better structure for a dictionary item like this? Is there a better 
>>> solution I could be using?
>>> 
>>> Any help is much appreciated.
>>> 
>>> Thanks,
>>> 
>>> Doug.
>> 
>>> -- 
>>> -- 
>>> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>>>  
>>> 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
>>> 
>>> --- 
>>> You received this message because you are subscribed to the Google Groups 
>>> "jBASE" group.
>>> To unsubscribe from this group and stop receiving emails from it, send an 
>>> email to jbase+un...@googlegroups.com.
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/jbase/2faaf941-59db-46a3-932b-4f40777635d4n%40googlegroups.com.
> 
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/8ebe088a-6959-4636-b06f-eeb030addc1an%40googlegroups.com.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

To post, send email to jBASE@googlegroups.com
To unsubscribe, send em

Re: Count records using Dictionary

2021-12-23 Thread Peter Falson
Thanks Doug. That’s the default config and your example looks to be working on 
the upcoming release.

Sent from my iPhone

> On Dec 23, 2021, at 8:05 AM, dfleetham_HMA  
> wrote:
> 
> 
> Hi Peter,
> 
> config-strings output is:
> JBCRELEASEDIR  : D:\jBase\5.8.2
> JBCGLOBALDIR   : D:\jBase\global
> JBCEMULATE : jbase
> Emulation file : D:\jBase\global\config\Config_EMULATE
> 
> compiler_options ""
> dates_upper_case true
> enter_keeps_common_data  false
> error_numbers_are_single_attribute   false
> itype_trans_replace_delimfalse
> itype_unquoted_numeric_literal   true
> jbase_field  true
> list_keystrue
> lock_strategythread
> named_common null
> old_jql_output_style false
> readv0   key
> reality_videotrue
> treat_with_as_or_withtrue
> unnamed_common   unassigned
> use_sql_syntax_for_selectfalse
> 
> Thanks,
> 
> Doug.
> 
>> On Wednesday, 22 December 2021 at 13:29:17 UTC-8 pfalson wrote:
>> Doug,
>> 
>> This may have been patched but can you post the output of
>> 
>> config-strings 
>> 
>> 
>> Sent from my iPhone
>> 
 On Dec 22, 2021, at 11:25 AM, dfleetham_HMA  
 wrote:
 
>>> Hi All,
>> 
>>> 
>>> 
>>> We've recently (ish) moved from to 5.8.2 from I have no idea what (4.#?).
>>> 
>>> In the previous iteration I had a dictionary item that I added to most 
>>> files and it was labelled 'CNT'. It was a fixed value of 1 and looked like:
>>> 
>>> CNT
>>> 001 I
>>> 002 1
>>> 003 MR0,
>>> 004 CNT
>>> 005 8R
>>> 
>>> And it was useful for counting records in a report; if I ran a query like:
>>> 
>>> SORT D:\D_Shared\This Client\ThatCampaign\CUST_GIFT_DATA BY 28 BREAK-ON 28 
>>> TOTAL 22 TOTAL CNT (ID
>>> 
>>> I would get something like:
>>> 
>>> Last Gift.Gift AmtCNT.
>>> Year  
>>> 
>>>   2014   $75.00   3
>>>   2015   $85.00   4
>>>   2016   $95.00   4
>>>   2017   $65.00   2
>>>   2018   $80.00   3
>>>   2019   $90.00   3
>>>    
>>> ***  $490.00 19
>>> 
>>> Having moved to 5.8.2, the CNT dictionary item doesn't seem to work and 
>>> running the same query, I get:
>>> 
>>> Last Gift.Gift AmtCNT.
>>> Year  
>>> 
>>>   2014   $75.00   0
>>>   2015   $85.00   0
>>>   2016   $95.00   0
>>>   2017   $65.00   0
>>>   2018   $80.00   0
>>>   2019   $90.00   0
>>>    
>>> ***  $490.00  0
>>> 
>>> There's probably a very simple solution; I just haven't found it. Is there 
>>> a better structure for a dictionary item like this? Is there a better 
>>> solution I could be using?
>>> 
>>> Any help is much appreciated.
>>> 
>>> Thanks,
>>> 
>>> Doug.
>> 
>>> -- 
>>> -- 
>>> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>>>  
>>> 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
>>> 
>>> --- 
>>> You received this message because you are subscribed to the Google Groups 
>>> "jBASE" group.
>>> To unsubscribe from this group and stop receiving emails from it, send an 
>>> email to jbase+un...@googlegroups.com.
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/jbase/2faaf941-59db-46a3-932b-4f40777635d4n%40googlegroups.com.
> 
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/8ebe088a-6959-4636-b06f-eeb030addc1an%40googlegroups.com.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To uns

Re: Count records using Dictionary

2021-12-22 Thread Peter Falson
Doug,

This may have been patched but can you post the output of

config-strings 


Sent from my iPhone

> On Dec 22, 2021, at 11:25 AM, dfleetham_HMA  
> wrote:
> 
> Hi All,
> 
> We've recently (ish) moved from to 5.8.2 from I have no idea what (4.#?).
> 
> In the previous iteration I had a dictionary item that I added to most files 
> and it was labelled 'CNT'. It was a fixed value of 1 and looked like:
> 
> CNT
> 001 I
> 002 1
> 003 MR0,
> 004 CNT
> 005 8R
> 
> And it was useful for counting records in a report; if I ran a query like:
> 
> SORT D:\D_Shared\This Client\ThatCampaign\CUST_GIFT_DATA BY 28 BREAK-ON 28 
> TOTAL 22 TOTAL CNT (ID
> 
> I would get something like:
> 
> Last Gift.Gift AmtCNT.
> Year  
> 
>   2014   $75.00   3
>   2015   $85.00   4
>   2016   $95.00   4
>   2017   $65.00   2
>   2018   $80.00   3
>   2019   $90.00   3
>    
> ***  $490.00 19
> 
> Having moved to 5.8.2, the CNT dictionary item doesn't seem to work and 
> running the same query, I get:
> 
> Last Gift.Gift AmtCNT.
> Year  
> 
>   2014   $75.00   0
>   2015   $85.00   0
>   2016   $95.00   0
>   2017   $65.00   0
>   2018   $80.00   0
>   2019   $90.00   0
>    
> ***  $490.00  0
> 
> There's probably a very simple solution; I just haven't found it. Is there a 
> better structure for a dictionary item like this? Is there a better solution 
> I could be using?
> 
> Any help is much appreciated.
> 
> Thanks,
> 
> Doug.
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/2faaf941-59db-46a3-932b-4f40777635d4n%40googlegroups.com.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jbase/2F7A4BBD-7048-43BC-A2AC-CA3E84C17816%40gmail.com.


Re: SORT to return only some multivalues?

2021-10-13 Thread Peter Falson
Use the value limiter along with the BY-EXP

https://docs.zumasys.com/jbase/jql/jql-keyword-cross-reference/by-exp/#by-exp-by-exp

Sent from my iPhone

> On Oct 13, 2021, at 5:56 AM, Joshua Camacho  wrote:
> 
> 
> I would like to be able to return a list of only multivalues that match a 
> criteria, rather than all multivalues of an item that contains a match in any 
> of the multivalues.
> 
> Example:
> On the INVENTORY file, the record key is ITEM.  PALLETS, PALLET.QTYS, and 
> PALLET.LOCS are all multivalue fields on the record.
> 
> 
> SORT INVENTORY BY-EXP PALLET.LOCS ITEM PALLETS TOTAL PALLET.Q
> TYS PALLET.LOCS WITH PALLET.LOCS = SPKM22
> 
> Returns:
> 
> INVENTORY. ITEM.. PALLETS... QTYS. LOC.
> 
> 1101660110166002107528  20 SPKM11
> 1101660110166002107523  20 SPKM13
> 1101660110166002107517  20 SPKM21
> 1101660110166002100266  20 SPKM22
> 1101660110166002107516  20 SPKM23
> 1101660110166002107521  20 SPKM31
> 1101660110166002107530  20 SPKM32
> 1101660110166002107533  20 SPKM33
>  =
>  ***160
> 
> I would like it to return only this:
> INVENTORY. ITEM.. PALLETS... QTYS. LOC.
> 
> 1101660110166002100266  20 SPKM22
>  =
>  ***20
> 
> Is there a way to do this?
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/CAAEHHzhQfWe6nM%3Dkg2s9N5425xc_To0VF4Ocx%2BTA%2BHjrt7XZ5w%40mail.gmail.com.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jbase/9298550F-2162-4343-AC02-66E45A0D0401%40gmail.com.


Re: Convert file to folder (UD)

2021-08-04 Thread Peter Falson
FWIW you can do

COPY FROM onefile TO anotherfile ALL {OVERWRITING}

The OVERWRITING will be quicker.

Sent from my iPhone

> On Aug 4, 2021, at 1:52 AM, Stuart Boydell 
>  wrote:
> 
> I just discovered the alternate COPY format works for this scenario.
> COPY FROM $fileName TO $tmpFolder ALL
> 
>> On Wednesday, 4 August 2021 at 11:49:28 UTC+10 Stuart Boydell wrote:
>> I'm currently trying to do this from a bash script but I'm not sure how to 
>> pipe into the COPY command.
>> Can anyone suggest something that works along the lines of:
>> 
>> mkdir tmp123
>> echo "(tmp123"|COPY DICT MYFILE *
>> 
>> This just seems to try to copy contents of the current folder to itself!
>> 
>>> On Saturday, 24 July 2021 at 20:50:58 UTC+10 mvr...@zumasys.com wrote:
>>> Stuart,
>>> 
>>> This option is meant for resizing hashed source code files to a folder and 
>>> does include an OBJECT data section.
>>> 
>>>  
>>> 
>>> There is currently no option to resize to a regular TYPE=UD.
>>> 
>>> This works on Windows but seems to be a problem on Linux.
>>> 
>>>  
>>> 
>>> We will look into it.
>>> 
>>>  
>>> 
>>> Mike
>>> 
>>>  
>>> 
>>> From: jb...@googlegroups.com  On Behalf Of Stuart 
>>> Boydell
>>> Sent: 23 July 2021 08:38
>>> To: jBASE 
>>> Subject: Convert file to folder (UD)
>>> 
>>>  
>>> 
>>> jrf -jHbc option to resize a hashed file to an OS folder doesn't seem to 
>>> work. Is there a trick or alternative to resize to an OS folder?
>>> 
>>>  
>>> 
>>> Also, if I can get it working - will this create an OBJECT part - which I 
>>> don't want?
>>> 
>>>  
>>> 
>>> In a zumasys/jbase:latest container:
>>> 
>>>  
>>> 
>>> >CREATE-FILE TEST1
>>> 
>>> [ 417 ] File TEST1]D created , type = JD
>>> 
>>> [ 417 ] File TEST1 created , type = JD
>>> 
>>> >OFF
>>> 
>>> sh-4.4# jsh -a TEST
>>> 
>>> >jrf -Hjbc TEST1
>>> 
>>> /jbasedata/dbms/TEST/TEST1 is currently an empty file
>>> 
>>> (R)esize anyway or (S)kip file resize: R
>>> 
>>> MOVE /jbasedata/dbms/TEST/1tmp.jrf to /jbasedata/dbms/TEST/TEST1 failed 
>>> with error: 20
>>> 
>>> Resize of /jbasedata/dbms/TEST/TEST1 was skipped!
>>> 
>>> 0 file(s) resized.
>>> 
>>> 1 file(s) skipped and could not be overwritten (probably in use)...
>>> 
>>> MOVE /jbasedata/dbms/TEST/1tmp.jrf to /jbasedata/dbms/TEST/TEST1 failed 
>>> with error: 20
>>> 
>>> Elapsed: 00:00:05
>>> 
>>> -- 
>>> -- 
>>> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>>>  
>>> 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
>>> 
>>> --- 
>>> You received this message because you are subscribed to the Google Groups 
>>> "jBASE" group.
>>> To unsubscribe from this group and stop receiving emails from it, send an 
>>> email to jbase+un...@googlegroups.com.
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/jbase/6a244bbf-5ec3-4869-8bff-c7fac02293a4n%40googlegroups.com.
>>> 
> 
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/ee4ab625-73f1-4399-a7ea-8f42a5517772n%40googlegroups.com.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jbase/CC529017-65BF-4704-89C8-4DEB5651899B%40gmail.com.


Re: Unit test framework for MV

2021-07-23 Thread Peter Falson
http://www.mvdeveloper.com/pages/test.htm

Sent from my iPhone

> On Jul 23, 2021, at 10:59 AM, Stuart Boydell 
>  wrote:
> 
> Has anyone come across a unit test framework for MV? Something like xUnit?
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/dd0cd0eb-ab5d-4eb6-9c79-b19d41b81fbcn%40googlegroups.com.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jbase/E4E07C1A-C435-4FD6-8A9A-C290811CA94E%40gmail.com.


Re: JOIN STATEMENT -jBase

2021-06-20 Thread Peter Falson
Alternatively if you use SQLSELECT instead of LIST/SORT then normal SQL rules 
would apply (either using a JOIN or a WHERE clause).

Sent from my iPhone

> On Jun 19, 2021, at 1:01 PM, Joshua Camacho  wrote:
> 
> 
> You will need to make a referencing dictionary entry on the CLIENTS table to 
> the CUSTOMER_BIO table. Assuming that both tables have the same Key of 
> Customer number, and that the phone number is stored on attribute 10 of the 
> CUSTOMER_BIO record, the dictionary on the CLIENTS table would look like this:
> 
> DICT CLIENTS PHONE_NO
> 
> 001 A
> 002 0
> 003 PHONE NO
> 004
> 005
> 006
> 007 TCUSTOMER_BIO;x;;10
> 008
> 009 L
> 010 11
> 
> It's the attribute in attr002 and the calculation in Attr007 that tells jBASE 
> to fetch (T) from CUSTOMER_BIO, record 0 (attr2 of this dictionary), and 
> return attribute 10. I'm not sure what the x and the extra semicolon do, but 
> I know they need to be there.
> 
> This would allow you to run the following command, assuming that CLIENT_ID 
> and SERVICE_TYPE exist as dictionary entries on CLIENTS table:
> 
> LIST CLIENTS CLIENT_ID SERVICE_TYPE PHONE_NO
> 
> More information about this exists at 
> https://docs.zumasys.com/jbase/jql/data-definition-records-and-dictionary-structure/
> 
> 
> 
> Joshua Camacho
> wyck...@gmail.com
> (773) 988-0846
> 
> 
>> On Sat, Jun 19, 2021 at 1:14 PM Prince Bismark  
>> wrote:
>> All,
>> I have two tables, CUSTOMER_BIO which contains all the bio data of the 
>> clients including PHONE_NUMBER and CUST_ID and the second table CLIENTS 
>> which contains CLIENT_ID, CUST_ID,SERVICE_TYPE.
>> I want to extract on CLIENTS TABLE, CLIENT_ID AND SERVICE_TYPE and 
>> PHONE_NUMBER
>> 
>> Any help?
>> -- 
>> -- 
>> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>>  
>> To post, send email to jBASE@googlegroups.com
>> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
>> For more options, visit this group at 
>> http://groups.google.com/group/jBASE?hl=en
>> 
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "jBASE" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to jbase+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/jbase/CACwaXCnWrAY-RFOVL2EsnhFbi2QiwRtvNBKkpKWU2JoQ%3DN6L5Q%40mail.gmail.com.
> 
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/CAAEHHziaUR_v1tR9v%2BL7cnv-wWLS8_tLSjGSxepJnWdqizovZg%40mail.gmail.com.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jbase/B39F73A9-E441-46E8-A5F9-3154F0D03649%40gmail.com.


Re: @USERx variables

2021-06-09 Thread Peter Falson
The @USER variables are now available in jBASE 5.8.

Sent from my iPhone

> On Jun 9, 2021, at 6:09 AM, bdeck...@gmail.com  wrote:
> 
> 
> Agree with Marcus that a named common is a simple and effective way to 
> emulate this sort of thing and to be platform neutral if desired.  Certain 
> items will be static and will not change within a session.  Others, such as 
> jBASE's ability to return complete stack information, will change naturally 
> via program flow.  For these, you'll still need to call to the native 
> function at the time you need the info.
> 
> 
>> On Wednesday, June 9, 2021 at 6:42:46 AM UTC-6 marcus.aure...@gmail.com 
>> wrote:
>> This is one of those things I think all of us has had to find some way of 
>> emulating in code.  In my case, I wrote an include called UBIQUITOUS_STUFF.  
>> It's basically a named common, dimensioned-array.  It's initialized just 
>> once at login by a program called UBIQUITOUS_STUFFER, just because I'm like 
>> that.  And what this stuffer program does is populate the UBIQUITOUS array 
>> with everything that probably ought to be globally available, like username, 
>> home path, emulator details, terminal details, host type, etc.  I even made 
>> mine platform independent with a bunch of platform-specific subroutines to 
>> handle things like port number:  On most flavors, it's SYSTEM(18), but on D3 
>> it's SYSTEM(22), and on UniData, it's @USERNO.
>> 
>> I've never been a fan of equating array indices to names, but I've also 
>> never been a fan of things like SYSTEM(24) either, especially where flavors 
>> differ, so my include names every element of the array just so the code 
>> reads more like English.
>> 
>> Just add your include to a program, and you have access to everything.
>> 
>>> On Wednesday, June 9, 2021 at 6:55:24 AM UTC-4 joha...@gmail.com wrote:
>>> 
>>> As I am new to jBase but not new to multi-value, one of the things I cannot 
>>> find is something available elsewhere in the form of @USER variables. These 
>>> are global and vary useful for carrying data around the system for easy 
>>> access no matter where you are, programs, functions, I-Types, triggers etc. 
>>> I did some searching but since I do not know what the jBase equivalent is, 
>>> my search came back empty. Any pointers to a similar feature will be 
>>> appreciated. Thanks :)
> 
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/745e41c1-4ca9-42cd-9689-f6f2c3fb0c85n%40googlegroups.com.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jbase/13C8659B-4AD4-4386-BBBA-B7B7652E50F8%40gmail.com.


Re: Looping a GOSUB

2021-06-04 Thread Peter Falson
What version of jBASE are you using? We support curl natively now 

https://docs.zumasys.com/jbase/miscellaneous/jcurl/#additional-helper-functions

Sent from my iPhone

> On Jun 4, 2021, at 5:29 AM, Johan Liebenberg  wrote:
> 
> 
> Building a small batch file to run on a Window jBase server.
> 
> Batch file executes a curl command build inside the jBase program.
> 
> I 1st tried to EXECUTE the curl command CAPTURING RESULTS, but the remote 
> server returns an error. I filtered all the illegal character out of the curl 
> command just in case. No luck.This happens to work flawlessly on a Linux 
> server.
> 
> So the next approach is to create a DOS batch file and execute the batch file 
> with the curl command inside the batch file. Works 1st time but then the 
> trouble starts:
> 
> So I have a GOSUB RUNCMD that calls the sub below with the curl command 
> inside the CMD variable:
> RUNCMD:
> 
>  OSDELETE 'temp.bat'
> 
> EXECUTE 'touch temp.bat' CAPTURING JUNK
> 
> OSOPEN 'temp.bat' TO TEMPDOSFILE THEN
> 
> OSBWRITE CMD ON TEMPDOSFILE AT 0
> 
> OSCLOSE TEMPDOSFILE
> 
> EXECUTE 'temp.bat' CAPTURING RESULTS
> 
> END
> 
> OSDELETE 'temp.bat'
> 
>  RETURN
> 
> With the debugger turned on, outside RUNCMD sub, I can follow the progress 
> through the sub line by line, everything works and the remote server receives 
> the curl command correctly and returns the correct data in the RESULTS 
> variable. All good. When the execution gets to the RETURN command, one 
> expects it to jump back to the 1st line after the GOSUB RUNCMD, but instead 
> it jumps back to the RUNCMD: label and it repeats the sub over and over in a 
> loop that you can not break out of. 
> 
> Surely I am very tired because it is late and I am missing something really 
> really obvious. Thanks for looking :)
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/64144341-a743-4e2b-9824-8cfda8f609f9n%40googlegroups.com.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jbase/0398E108-D1AC-4B4B-AB8F-FC212992FE5B%40gmail.com.


Re: Call jBASE Function from Within a Proc?

2021-05-20 Thread Peter Falson
Additionally, depending on your jBASE version, you can place DEBUG ON in your 
proc (after the PQ) and view the buffers.

Sent from my iPhone

> On May 20, 2021, at 12:24 PM, m...@proman.com wrote:
> 
> 
> jBase used to support proc user exits, for compatibility with the old 
> assembler versions.
> I suspect the code still works.
> We don’t use them but here’s a sample, docs might still be out there 
> somewhere.
> The jpq_namedcommon variables allow for query and setting of the buffer 
> pointers.
>  
>   SUBROUTINE U088(result, source, code, type, error)
>   INCLUDE jpq_namedcommon
>   Ptr = IPBUFFPTR
>   IF Ptr > 1 THEN Ptr +=1 ; ! skip over the blank
>   IF PQproc THEN
>  Delim = " "
>   END ELSE
>  Delim = CHAR(254)
>   END
>   ucode = code<1,1,1>
> ! if called as U1088 then the prompt will be :
> ! if called as U(2-F) then the prompt will be "?"
> ! can thus be customized for 16 prompt chars
>   BEGIN CASE
>   CASE ucode = "1"
>  PROMPT ":"
>   CASE 1
>  PROMPT "?"
>   END CASE
>   INPUT Q
>   CurrData = IPBUFFER[Ptr,]
>   CData = FIELD(CurrData,Delim,1)
>   IF Q # "" THEN
> P1 = IPBUFFER[1,Ptr-1]
> P2 = CurrData[COL2(),999]
> IPBUFFER = P1:Q:P2
>   END
>   RETURN
>  
> From: jbase@googlegroups.com  On Behalf Of Joyce White
> Sent: Thursday, May 20, 2021 12:03 PM
> To: jBASE 
> Subject: Re: Call jBASE Function from Within a Proc?
>  
> Thanks, I find procs to be challenging because I'm not in them often. In this 
> case, I think I'm just going to write the check into the PROC. It should be a 
> pretty simple check. Thanks for the suggestions - I appreciate the advice and 
> help!
> Joyce
> 
> On Thursday, May 20, 2021 at 2:52:00 PM UTC-4 edclark wrote:
> No, I don’t think you can call it from proc directly. You would have to run 
> it. You probably need a wrapper program that would call your 
> subroutine—unless jBase lets you run subroutines now. Last time I used jBase 
> (quite a while ago) IIRC it didn’t allow you to CALL a program, or to EXECUTE 
> a subroutine. 
> A wrapper program can use SYSTEM(27) to determine if it is running from a 
> proc and use PROCREAD to get the parameter from the input buffer, or 
> SENTENCE() to get it from the command line (proc primary output buffer).
> 
> 
> On May 20, 2021, at 13:26, Joyce White  wrote:
>  
> So from your answer, it seems like I CAN call a jBASE subroutine from a proc, 
> just not with parameters? What is the syntax I would use to call a subroutine 
> with no parameters from a proc?
> Joyce
> 
> On Thursday, May 20, 2021 at 12:32:25 PM UTC-4 edclark wrote:
> Unless there have been some enhancements to icl, I don’t think that you can 
> call a subroutine with parameters.
> Your validation program can either parse the parameter from the command line, 
> or retrieve it with PROCREAD. It can use PROCWRITE to return its result, or 
> use STOP, and then the proc can check IF E
> 
> 
> On May 20, 2021, at 12:01, Joyce White  wrote:
>  
> Hi, I have a proc (jcl program) that needs a "date check". I'd like to write 
> a jBASE function for the date check, then call it from within the proc, 
> having it return to the proc after it checks the date. Is this doable? If so, 
> what syntax would I use to call the jBASE function (LIFE.LEFT.b) from within 
> the proc?
>  
> I'm trying the line below and it's not working. My function is LIFE.LEFT, and 
> it takes a parameter that the user enters in the previous line (%3).
>  
> IF [LIFE.LEFT(%3)] = 1 GO 999
>  
> Thanks,
> Joyce
>  
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> 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
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+un...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/54d2fd8d-7d18-4e88-804d-a447e01a689dn%40googlegroups.com.
>  
>  
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> 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
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+un...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/1f0a6ff7-4f75-4f85-ad18-1dc8507fbbf2n%40googlegroups.com.
>  
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsub

Re: weird jbase 5.5.1 error

2021-05-20 Thread Peter Falson
It looks like a Java install/upgrade has occurred. You can most likely amend 
your remote.cmd to put the %JBCRELEASEDIR%\bin at the start of your PATH.

Sent from my iPhone

> On May 20, 2021, at 4:52 AM, Richard Kann  wrote:
> 
> 
> Prior to today a jrf -R filename   would give me the stats on a file. Now I 
> get this:
> 
> jsh DEMO ~ -->JRF -R Z
> illegal argument: -D,
> Usage: jstat -help|-options
>jstat - [-t] [-h]  [ []]
> 
> Definitions:
> An option reported by the -options option
>   Virtual Machine Identifier. A vmid takes the following form:
>  [@[:]]
> Where  is the local vm identifier for the target
> Java virtual machine, typically a process id;  is
> the name of the host running the target Java virtual machine;
> and  is the port number for the rmiregistry on the
> target host. See the jvmstat documentation for a more complete
> description of the Virtual Machine Identifier.
>  Number of samples between header lines.
>   Sampling interval. The following forms are allowed:
> ["ms"|"s"]
> Where  is an integer and the suffix specifies the units as
> milliseconds("ms") or seconds("s"). The default units are 
> "ms".
>  Number of samples to take before terminating.
>   -J  Pass  directly to the runtime system.
>  is not a j# file - ignored
> ---
> jsh DEMO ~ -->
> 
> 
> 
> Does not make sense as I am not typing a -D. Not the keyboard as I tried it 
> on 2 units.
> 
> -- 
> Richard Kann
> 
> 
> 
> Comp-Ware Systems, Inc.
> phone: 800-494-7671
> email: rk...@comp-ware.net
> www.comp-ware.net
> 
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/58f61703-aaa4-18c6-f437-902e67feafc2%40COMP-WARE.NET.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jbase/B65FC9D4-DB08-4FCE-8C2F-87B76C138CA4%40gmail.com.


Re: SELECT of records in range

2020-08-01 Thread Peter Falson
In an RDBMS yes, on jBASE (MV platforms) you have to create an index. 

Sent from my iPhone

> On Aug 1, 2020, at 8:51 AM, VK  wrote:
> 
> 
> Sorry forgot to mention that there's no field with account number, it's just 
> a part of @ID. Isn't @ID a primary index itself?
> 
> 
>> On Friday, 31 July 2020 17:15:36 UTC+2, VK wrote:
>> Hi coleagues.
>> 
>> What is the fastest way to SELECT a set of records from a J4 table:
>> 
>> @IDs are in the format: (account_number)-(date_in_internal_format), e.g. 
>> 5001-18628.
>> 
>> trying:
>> 
>> SELECT THE.TABLE WITH @ID BETWEEN "5001-18628" "5001-23012"
>> 
>> Result is bit more than a second (Windows 2019 server, enough memory and 
>> CPUs). Maybe it can be improved?
>> 
>> usr: 1.11   sys: 0.00   elapsed: 0m1.11s
>> 
>> Usage of "GE ... LE" didn't help:
>> 
>> usr: 1.36   sys: 0.00   elapsed: 0m1.36s
>> 
>> Records number: circa 340,000.
>> 
>> Resizing didn't help.
>> 
>> Conversion to JR, as expected, made things a bit worse.
>> 
>> Thought about year-based distribution but haven't given it a try yet.
>> 
>> Last question - is jBASE indexing stable enough to be trusted? 
>> 
>> TAFC 13 (no, question isn't about T24!)
>> 
> 
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/ef1a5fa4-6e7d-498d-8c2a-b501af233ca5o%40googlegroups.com.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jbase/E4D147D8-A283-4BDE-A336-EE086F6E7BC2%40gmail.com.


Re: Getting the jBase DP (data pointer) of the current session when using pure C

2020-03-26 Thread Peter Falson
Right. What I’m suggesting is that any python programs would need to pass on 
the dp pointer down the chain. 

Sent from my iPhone

> On Mar 26, 2020, at 6:09 AM, Igor Osmolovskiy  wrote:
> 
> 
> Let's imagine we are in jshell, thus 1 session has been created already. Then
> 1. if we launch jBasic that calls .py there will be still 1 session (i.e. the 
> same one)
> 2. if we launch python that calls .py the second session will be created
> 
> in both cases the same C extension with jbase_getdpEX inside is used
> 
> среда, 25 марта 2020 г., 19:28:17 UTC пользователь pfalson написал:
>> Still not entirely sure why though. If python is the starting point and you 
>> get a dp from jbase_getdpEX (you cant avoid at least one session) you could 
>> pass the dp down the chain. 
>> 
>> Sent from my iPhone
>> 
 On Mar 25, 2020, at 10:15 AM, Igor Osmolovskiy  wrote:
 
>>> 
>>> Right. If a jBASE routine is the starting point - no new session is created.
>>> 
>>> But if python is the starting point then looks like we cannot avoid an 
>>> additional session
>>> 
>>> среда, 25 марта 2020 г., 14:25:33 UTC пользователь pfalson написал:
 Not following. If your starting point is jsh or LOGTO or a jBASE program 
 you should be able to call a python routine and convert the dp to a pylong 
 and pass it down for reuse.
 
 Sent from my iPhone
 
>> On Mar 25, 2020, at 7:14 AM, Igor Osmolovskiy  wrote:
>> 
> 
> Thanks Peter for your help
> 
> Coming back to the initial question whether a DP could be initialized 
> without a new session - looks like it is not possible.
> When we compile and catalog a JBC routine then a dll will be placed into 
> bin. And when that JBC routine is called then it is actually called as a 
> dll rather than executable (which can be removed even). So the same 
> address space is used.
> On the contrary when we call python then it is always a separate 
> executable with its own address space..
> 
> вторник, 10 марта 2020 г., 19:03:45 UTC пользователь pfalson написал:
>> https://github.com/pickmultivalue/jPython  
>> 
>>> On Tue, Mar 10, 2020 at 7:11 AM Igor Osmolovskiy  
>>> wrote:
>>> Would be interesting to have a look
>>> Thanks!
>>> 
>>> понедельник, 9 марта 2020 г., 19:31:07 UTC+1 пользователь pfalson 
>>> написал:
 
 Your only choices are start from jsh/jbc call python, call jbc etc or 
 start with python call jbc. 
 
 Either way the dp needs to be carried around. 
 
 I can post an example of calling python (it needs jBASE 5).
 
 Sent from my iPhone
 
>> On Mar 9, 2020, at 10:36 AM, Igor Osmolovskiy  
>> wrote:
>> 
> 
> Hello Dan
> Right, but is there a possibility to avoid creating a new thread? 
> One option proposed by Peter is to launch Pyhton from JBC e.g. But 
> any chance to achieve this for pure Pyhton?
> 
> понедельник, 9 марта 2020 г., 15:27:22 UTC+1 пользователь DanE 
> написал:
>> 
>> That would be because the jsh initiated the thread and the program 
>> running under it is a shared object /dll beneath that thread.
>> 
>>  
>> 
>> 
>> Dan Ell​  | jBASE Technical Engineer
>> jBASE International, Inc.
>> 813-498-2544 |   866‑582‑8447
>> d...@jbase.com | www.jbase.com
>> 1050 Calle Amanecer, Suite A | San Clemente, CA 92673
>> From: jb...@googlegroups.com  On Behalf Of 
>> Igor Osmolovskiy
>> Sent: Monday, March 9, 2020 6:10 AM
>> To: jBASE 
>> Subject: Re: Getting the jBase DP (data pointer) of the current 
>> session when using pure C
>>  
>> 
>> Thank you Peter
>> 
>>  
>> 
>> But do you think it is still possible to retrieve a DP for an 
>> existing session? 
>> 
>> It can be seen that no new session is created when a JBC program is 
>> being called in jshell e.g. Therefore a DP initialization is 
>> happening somehow for that case
>> 
>> Thanks
>> 
>> 
>> суббота, 7 марта 2020 г., 1:13:48 UTC+1 пользователь pfalson написал:
>> 
>> That creates a regular jBASE session dp. The null args are more for 
>> internal use. 
>> 
>> Sent from my iPhone 
>> 
>> > On Mar 6, 2020, at 2:56 PM, Igor Osmolovskiy  
>> > wrote: 
>> > 
>> > Peter, thanks for the code sample 
>> > 
>> > Could you please elaborate on what exactly the next line means 
>> > jbase_getdpEX(NULL,NULL,1,NULL) 
>> > 
>> > Thanks 
>> > Igor 
>> > 
>> > -- 
>> > -- 
>> > IMPORTANT: T24/Globus p

Re: Getting the jBase DP (data pointer) of the current session when using pure C

2020-03-25 Thread Peter Falson
Still not entirely sure why though. If python is the starting point and you get 
a dp from jbase_getdpEX (you cant avoid at least one session) you could pass 
the dp down the chain. 

Sent from my iPhone

> On Mar 25, 2020, at 10:15 AM, Igor Osmolovskiy  wrote:
> 
> 
> Right. If a jBASE routine is the starting point - no new session is created.
> 
> But if python is the starting point then looks like we cannot avoid an 
> additional session
> 
> среда, 25 марта 2020 г., 14:25:33 UTC пользователь pfalson написал:
>> Not following. If your starting point is jsh or LOGTO or a jBASE program you 
>> should be able to call a python routine and convert the dp to a pylong and 
>> pass it down for reuse.
>> 
>> Sent from my iPhone
>> 
 On Mar 25, 2020, at 7:14 AM, Igor Osmolovskiy  wrote:
 
>>> 
>>> Thanks Peter for your help
>>> 
>>> Coming back to the initial question whether a DP could be initialized 
>>> without a new session - looks like it is not possible.
>>> When we compile and catalog a JBC routine then a dll will be placed into 
>>> bin. And when that JBC routine is called then it is actually called as a 
>>> dll rather than executable (which can be removed even). So the same address 
>>> space is used.
>>> On the contrary when we call python then it is always a separate executable 
>>> with its own address space..
>>> 
>>> вторник, 10 марта 2020 г., 19:03:45 UTC пользователь pfalson написал:
 https://github.com/pickmultivalue/jPython  
 
> On Tue, Mar 10, 2020 at 7:11 AM Igor Osmolovskiy  wrote:
> Would be interesting to have a look
> Thanks!
> 
> понедельник, 9 марта 2020 г., 19:31:07 UTC+1 пользователь pfalson написал:
>> 
>> Your only choices are start from jsh/jbc call python, call jbc etc or 
>> start with python call jbc. 
>> 
>> Either way the dp needs to be carried around. 
>> 
>> I can post an example of calling python (it needs jBASE 5).
>> 
>> Sent from my iPhone
>> 
 On Mar 9, 2020, at 10:36 AM, Igor Osmolovskiy  wrote:
 
>>> 
>>> Hello Dan
>>> Right, but is there a possibility to avoid creating a new thread? 
>>> One option proposed by Peter is to launch Pyhton from JBC e.g. But any 
>>> chance to achieve this for pure Pyhton?
>>> 
>>> понедельник, 9 марта 2020 г., 15:27:22 UTC+1 пользователь DanE написал:
 
 That would be because the jsh initiated the thread and the program 
 running under it is a shared object /dll beneath that thread.
 
  
 
 
 Dan Ell​| jBASE Technical Engineer
 jBASE International, Inc.
 813-498-2544 | 866‑582‑8447
 d...@jbase.com |   www.jbase.com
 1050 Calle Amanecer, Suite A | San Clemente, CA 92673
 From: jb...@googlegroups.com  On Behalf Of 
 Igor Osmolovskiy
 Sent: Monday, March 9, 2020 6:10 AM
 To: jBASE 
 Subject: Re: Getting the jBase DP (data pointer) of the current 
 session when using pure C
  
 
 Thank you Peter
 
  
 
 But do you think it is still possible to retrieve a DP for an existing 
 session? 
 
 It can be seen that no new session is created when a JBC program is 
 being called in jshell e.g. Therefore a DP initialization is happening 
 somehow for that case
 
 Thanks
 
 
 суббота, 7 марта 2020 г., 1:13:48 UTC+1 пользователь pfalson написал:
 
 That creates a regular jBASE session dp. The null args are more for 
 internal use. 
 
 Sent from my iPhone 
 
 > On Mar 6, 2020, at 2:56 PM, Igor Osmolovskiy  
 > wrote: 
 > 
 > Peter, thanks for the code sample 
 > 
 > Could you please elaborate on what exactly the next line means 
 > jbase_getdpEX(NULL,NULL,1,NULL) 
 > 
 > Thanks 
 > Igor 
 > 
 > -- 
 > -- 
 > IMPORTANT: T24/Globus posts are no longer accepted on this forum. 
 > 
 > 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 
 > 
 > --- 
 > You received this message because you are subscribed to the Google 
 > Groups "jBASE" group. 
 > To unsubscribe from this group and stop receiving emails from it, 
 > send an email to jb...@googlegroups.com. 
 > To view this discussion on the web visit 
 > https://groups.google.com/d/msgid/jbase/050fac31-e1aa-46e0-99bd-59d6f8dcdea7%40googlegroups.com.
 
 -- 
 -- 
 IMPORTANT: T24/Globus posts are no longer accepted on this forum.
  
 To post, send

Re: Getting the jBase DP (data pointer) of the current session when using pure C

2020-03-25 Thread Peter Falson
Not following. If your starting point is jsh or LOGTO or a jBASE program you 
should be able to call a python routine and convert the dp to a pylong and pass 
it down for reuse.

Sent from my iPhone

> On Mar 25, 2020, at 7:14 AM, Igor Osmolovskiy  wrote:
> 
> 
> Thanks Peter for your help
> 
> Coming back to the initial question whether a DP could be initialized without 
> a new session - looks like it is not possible.
> When we compile and catalog a JBC routine then a dll will be placed into bin. 
> And when that JBC routine is called then it is actually called as a dll 
> rather than executable (which can be removed even). So the same address space 
> is used.
> On the contrary when we call python then it is always a separate executable 
> with its own address space..
> 
> вторник, 10 марта 2020 г., 19:03:45 UTC пользователь pfalson написал:
>> https://github.com/pickmultivalue/jPython  
>> 
>>> On Tue, Mar 10, 2020 at 7:11 AM Igor Osmolovskiy  wrote:
>>> Would be interesting to have a look
>>> Thanks!
>>> 
>>> понедельник, 9 марта 2020 г., 19:31:07 UTC+1 пользователь pfalson написал:
 
 Your only choices are start from jsh/jbc call python, call jbc etc or 
 start with python call jbc. 
 
 Either way the dp needs to be carried around. 
 
 I can post an example of calling python (it needs jBASE 5).
 
 Sent from my iPhone
 
>> On Mar 9, 2020, at 10:36 AM, Igor Osmolovskiy  wrote:
>> 
> 
> Hello Dan
> Right, but is there a possibility to avoid creating a new thread? 
> One option proposed by Peter is to launch Pyhton from JBC e.g. But any 
> chance to achieve this for pure Pyhton?
> 
> понедельник, 9 марта 2020 г., 15:27:22 UTC+1 пользователь DanE написал:
>> 
>> That would be because the jsh initiated the thread and the program 
>> running under it is a shared object /dll beneath that thread.
>> 
>>  
>> 
>> 
>> Dan Ell​  | jBASE Technical Engineer
>> jBASE International, Inc.
>> 813-498-2544 |   866‑582‑8447
>> d...@jbase.com | www.jbase.com
>> 1050 Calle Amanecer, Suite A | San Clemente, CA 92673
>> From: jb...@googlegroups.com  On Behalf Of Igor 
>> Osmolovskiy
>> Sent: Monday, March 9, 2020 6:10 AM
>> To: jBASE 
>> Subject: Re: Getting the jBase DP (data pointer) of the current session 
>> when using pure C
>>  
>> 
>> Thank you Peter
>> 
>>  
>> 
>> But do you think it is still possible to retrieve a DP for an existing 
>> session? 
>> 
>> It can be seen that no new session is created when a JBC program is 
>> being called in jshell e.g. Therefore a DP initialization is happening 
>> somehow for that case
>> 
>> Thanks
>> 
>> 
>> суббота, 7 марта 2020 г., 1:13:48 UTC+1 пользователь pfalson написал:
>> 
>> That creates a regular jBASE session dp. The null args are more for 
>> internal use. 
>> 
>> Sent from my iPhone 
>> 
>> > On Mar 6, 2020, at 2:56 PM, Igor Osmolovskiy  wrote: 
>> > 
>> > Peter, thanks for the code sample 
>> > 
>> > Could you please elaborate on what exactly the next line means 
>> > jbase_getdpEX(NULL,NULL,1,NULL) 
>> > 
>> > Thanks 
>> > Igor 
>> > 
>> > -- 
>> > -- 
>> > IMPORTANT: T24/Globus posts are no longer accepted on this forum. 
>> > 
>> > 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 
>> > 
>> > --- 
>> > You received this message because you are subscribed to the Google 
>> > Groups "jBASE" group. 
>> > To unsubscribe from this group and stop receiving emails from it, send 
>> > an email to jb...@googlegroups.com. 
>> > To view this discussion on the web visit 
>> > https://groups.google.com/d/msgid/jbase/050fac31-e1aa-46e0-99bd-59d6f8dcdea7%40googlegroups.com.
>> 
>> -- 
>> -- 
>> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>>  
>> 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
>> 
>> --- 
>> You received this message because you are subscribed to the Google 
>> Groups "jBASE" group.
>> To unsubscribe from this group and stop receiving emails from it, send 
>> an email to jb...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/jbase/3308135a-4d22-4124-88c0-d5b693d9ed2d%40googlegroups.com.
>> 
> 
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jb...@googlegroups.com
> To unsubscribe, send e

Re: Getting the jBase DP (data pointer) of the current session when using pure C

2020-03-09 Thread Peter Falson
Your only choices are start from jsh/jbc call python, call jbc etc or start 
with python call jbc. 

Either way the dp needs to be carried around. 

I can post an example of calling python (it needs jBASE 5).

Sent from my iPhone

> On Mar 9, 2020, at 10:36 AM, Igor Osmolovskiy  wrote:
> 
> 
> Hello Dan
> Right, but is there a possibility to avoid creating a new thread? 
> One option proposed by Peter is to launch Pyhton from JBC e.g. But any chance 
> to achieve this for pure Pyhton?
> 
> понедельник, 9 марта 2020 г., 15:27:22 UTC+1 пользователь DanE написал:
>> 
>> That would be because the jsh initiated the thread and the program running 
>> under it is a shared object /dll beneath that thread.
>> 
>>  
>> 
>> 
>> Dan Ell​  | jBASE Technical Engineer
>> jBASE International, Inc.
>> 813-498-2544 |   866‑582‑8447
>> d...@jbase.com | www.jbase.com
>> 1050 Calle Amanecer, Suite A | San Clemente, CA 92673
>> From: jb...@googlegroups.com  On Behalf Of Igor 
>> Osmolovskiy
>> Sent: Monday, March 9, 2020 6:10 AM
>> To: jBASE 
>> Subject: Re: Getting the jBase DP (data pointer) of the current session when 
>> using pure C
>>  
>> 
>> Thank you Peter
>> 
>>  
>> 
>> But do you think it is still possible to retrieve a DP for an existing 
>> session? 
>> 
>> It can be seen that no new session is created when a JBC program is being 
>> called in jshell e.g. Therefore a DP initialization is happening somehow for 
>> that case
>> 
>> Thanks
>> 
>> 
>> суббота, 7 марта 2020 г., 1:13:48 UTC+1 пользователь pfalson написал:
>> 
>> That creates a regular jBASE session dp. The null args are more for internal 
>> use. 
>> 
>> Sent from my iPhone 
>> 
>> > On Mar 6, 2020, at 2:56 PM, Igor Osmolovskiy  wrote: 
>> > 
>> > Peter, thanks for the code sample 
>> > 
>> > Could you please elaborate on what exactly the next line means 
>> > jbase_getdpEX(NULL,NULL,1,NULL) 
>> > 
>> > Thanks 
>> > Igor 
>> > 
>> > -- 
>> > -- 
>> > IMPORTANT: T24/Globus posts are no longer accepted on this forum. 
>> > 
>> > 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 
>> > 
>> > --- 
>> > You received this message because you are subscribed to the Google Groups 
>> > "jBASE" group. 
>> > To unsubscribe from this group and stop receiving emails from it, send an 
>> > email to jb...@googlegroups.com. 
>> > To view this discussion on the web visit 
>> > https://groups.google.com/d/msgid/jbase/050fac31-e1aa-46e0-99bd-59d6f8dcdea7%40googlegroups.com.
>> 
>> -- 
>> -- 
>> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>>  
>> 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
>> 
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "jBASE" group.
>> To unsubscribe from this group and stop receiving emails from it, send an 
>> email to jb...@googlegroups.com.
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/jbase/3308135a-4d22-4124-88c0-d5b693d9ed2d%40googlegroups.com.
>> 
> 
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/4d42aaec-5bed-4546-a748-4ccdc51a563e%40googlegroups.com.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jbase/70861CBC-AA46-4B2F-A6AC-147448AC770D%40gmail.com.


Re: Getting the jBase DP (data pointer) of the current session when using pure C

2020-03-09 Thread Peter Falson
If you want to use python in this mix then I would think you need to call 
python from jBASE so you can persist the dp. 

Sent from my iPhone

> On Mar 9, 2020, at 6:28 AM, Igor Osmolovskiy  wrote:
> 
> 
> Thank you Peter
> 
> But do you think it is still possible to retrieve a DP for an existing 
> session? 
> It can be seen that no new session is created when a JBC program is being 
> called in jshell e.g. Therefore a DP initialization is happening somehow for 
> that case
> Thanks
> 
> суббота, 7 марта 2020 г., 1:13:48 UTC+1 пользователь pfalson написал:
>> 
>> That creates a regular jBASE session dp. The null args are more for internal 
>> use. 
>> 
>> Sent from my iPhone 
>> 
>> > On Mar 6, 2020, at 2:56 PM, Igor Osmolovskiy  wrote: 
>> > 
>> > Peter, thanks for the code sample 
>> > 
>> > Could you please elaborate on what exactly the next line means 
>> > jbase_getdpEX(NULL,NULL,1,NULL) 
>> > 
>> > Thanks 
>> > Igor 
>> > 
>> > -- 
>> > -- 
>> > IMPORTANT: T24/Globus posts are no longer accepted on this forum. 
>> > 
>> > 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 
>> > 
>> > --- 
>> > You received this message because you are subscribed to the Google Groups 
>> > "jBASE" group. 
>> > To unsubscribe from this group and stop receiving emails from it, send an 
>> > email to jb...@googlegroups.com. 
>> > To view this discussion on the web visit 
>> > https://groups.google.com/d/msgid/jbase/050fac31-e1aa-46e0-99bd-59d6f8dcdea7%40googlegroups.com.
>> >  
> 
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/3308135a-4d22-4124-88c0-d5b693d9ed2d%40googlegroups.com.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jbase/BDC0BAEB-BBEB-4F86-B508-08374E9E4028%40gmail.com.


Re: Getting the jBase DP (data pointer) of the current session when using pure C

2020-03-06 Thread Peter Falson
Whichever method you use to get a dp, it is up to you to store it in a 
persistent object. 

Sent from my iPhone

> On Mar 6, 2020, at 2:56 PM, Igor Osmolovskiy  wrote:
> 
> 
> Peter, we are using jBase 5.1
> 
> I've now tried  to use
>  static DPSTRUCT *dp = jbase_getdp_nocreate(NULL,NULL,1,NULL);
> but it still creates a new session...
> 
> Would that be possible maybe to give an example of how jbase_getdp_nocreate() 
> could be used please?
> Its name sounds like intending not to create a new dp :)
> thanks
> 
> среда, 4 марта 2020 г., 21:08:25 UTC+1 пользователь pfalson написал:
>> 
>> What version of jBASE do you have?
>> 
>> Sent from my iPhone
>> 
 On Mar 4, 2020, at 10:55 AM, Igor Osmolovskiy  wrote:
 
>>> 
>>> Thanks Peter, would be really helpful!
>>> 
>>> I've tried two ways
>>> 1. ctypes library. I managed to call a JBC function but it requires quite a 
>>> lot work as the explicit variable types are required in this case. So all 
>>> the transformations from PythonObj to a C type is required for each 
>>> argument. Also in many cases polymorphismе would be required as JBC 
>>> arguments often assume different types.
>>> 2. building a python library via distutils and working with PythonObj only. 
>>> As I've mentioned already this works but was not able to get rid of the 
>>> additional session being created at the step of "import lib" in python code.
>>> 
>>> среда, 4 марта 2020 г., 16:11:12 UTC+1 пользователь pfalson написал:
 
 We have some examples of python calling a subroutine and vice versa. I 
 will dig around. 
 
 Sent from my iPhone
 
>> On Mar 4, 2020, at 7:05 AM, Igor Osmolovskiy  wrote:
>> 
> 
> Hello
> pls see my response to Jim with the code sample
> 
> вторник, 3 марта 2020 г., 21:06:27 UTC+1 пользователь pfalson написал:
>> 
>> Can you post some code?
>> 
>> Sent from my iPhone
>> 
 On Mar 3, 2020, at 11:19 AM, Igor Osmolovskiy  wrote:
 
>>> 
>>> Dear all
>>> 
>>> I need the jBase DP (data pointer) to be initialized. I've actually 
>>> managed to initialize it by calling the jbase_getdp(). But in both 
>>> cases the new child session is created in jshell (and gets removed 
>>> automatically after the code has been executed).
>>> 
>>> So I am wondering: is there a possibility to retrieve and use the 
>>> current session DP somehow? So that no child session would get created
>>> 
>>> Any advice would be highly appreciated
>>> 
>>> Thanks in advance
>>> 
>>> 
>>> PS: to the admin, it is actually a jBase related question rather than 
>>> TAFC. Thanks
>>> 
>>> 
>>> Kind regards,
>>> Igor
>>> -- 
>>> -- 
>>> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>>>  
>>> 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
>>> 
>>> --- 
>>> You received this message because you are subscribed to the Google 
>>> Groups "jBASE" group.
>>> To unsubscribe from this group and stop receiving emails from it, send 
>>> an email to jb...@googlegroups.com.
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/jbase/73153581-25ae-493a-95f6-8afc5cdf7813%40googlegroups.com.
> 
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> 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
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jb...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/5c46377f-4c68-4f50-a5fb-9d1d8164232b%40googlegroups.com.
>>> 
>>> -- 
>>> -- 
>>> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>>>  
>>> 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
>>> 
>>> --- 
>>> You received this message because you are subscribed to the Google Groups 
>>> "jBASE" group.
>>> To unsubscribe from this group and stop receiving emails from it, send an 
>>> email to jb...@googlegroups.com.
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/jbase/8ed5e66b-8076-495b-8b66-c7db7d4e8629%40googlegroups.com.
> 
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
>

Re: Getting the jBase DP (data pointer) of the current session when using pure C

2020-03-06 Thread Peter Falson
That creates a regular jBASE session dp. The null args are more for internal 
use. 

Sent from my iPhone

> On Mar 6, 2020, at 2:56 PM, Igor Osmolovskiy  wrote:
> 
> Peter, thanks for the code sample
> 
> Could you please elaborate on what exactly the next line means
> jbase_getdpEX(NULL,NULL,1,NULL)
> 
> Thanks
> Igor
> 
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
> 
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/050fac31-e1aa-46e0-99bd-59d6f8dcdea7%40googlegroups.com.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jbase/28A9D49D-1995-4B04-9964-67D449E0D708%40gmail.com.


Re: Getting the jBase DP (data pointer) of the current session when using pure C

2020-03-04 Thread Peter Falson
What version of jBASE do you have?

Sent from my iPhone

> On Mar 4, 2020, at 10:55 AM, Igor Osmolovskiy  wrote:
> 
> 
> Thanks Peter, would be really helpful!
> 
> I've tried two ways
> 1. ctypes library. I managed to call a JBC function but it requires quite a 
> lot work as the explicit variable types are required in this case. So all the 
> transformations from PythonObj to a C type is required for each argument. 
> Also in many cases polymorphismе would be required as JBC arguments often 
> assume different types.
> 2. building a python library via distutils and working with PythonObj only. 
> As I've mentioned already this works but was not able to get rid of the 
> additional session being created at the step of "import lib" in python code.
> 
> среда, 4 марта 2020 г., 16:11:12 UTC+1 пользователь pfalson написал:
>> 
>> We have some examples of python calling a subroutine and vice versa. I will 
>> dig around. 
>> 
>> Sent from my iPhone
>> 
 On Mar 4, 2020, at 7:05 AM, Igor Osmolovskiy  wrote:
 
>>> 
>>> Hello
>>> pls see my response to Jim with the code sample
>>> 
>>> вторник, 3 марта 2020 г., 21:06:27 UTC+1 пользователь pfalson написал:
 
 Can you post some code?
 
 Sent from my iPhone
 
>> On Mar 3, 2020, at 11:19 AM, Igor Osmolovskiy  wrote:
>> 
> 
> Dear all
> 
> I need the jBase DP (data pointer) to be initialized. I've actually 
> managed to initialize it by calling the jbase_getdp(). But in both cases 
> the new child session is created in jshell (and gets removed 
> automatically after the code has been executed).
> 
> So I am wondering: is there a possibility to retrieve and use the current 
> session DP somehow? So that no child session would get created
> 
> Any advice would be highly appreciated
> 
> Thanks in advance
> 
> 
> PS: to the admin, it is actually a jBase related question rather than 
> TAFC. Thanks
> 
> 
> Kind regards,
> Igor
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> 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
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jb...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/73153581-25ae-493a-95f6-8afc5cdf7813%40googlegroups.com.
>>> 
>>> -- 
>>> -- 
>>> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>>>  
>>> 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
>>> 
>>> --- 
>>> You received this message because you are subscribed to the Google Groups 
>>> "jBASE" group.
>>> To unsubscribe from this group and stop receiving emails from it, send an 
>>> email to jb...@googlegroups.com.
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/jbase/5c46377f-4c68-4f50-a5fb-9d1d8164232b%40googlegroups.com.
> 
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/8ed5e66b-8076-495b-8b66-c7db7d4e8629%40googlegroups.com.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jbase/F16FECD2-1575-4ED5-B958-72A8ADB411CC%40gmail.com.


Re: Getting the jBase DP (data pointer) of the current session when using pure C

2020-03-04 Thread Peter Falson
We have some examples of python calling a subroutine and vice versa. I will dig 
around. 

Sent from my iPhone

> On Mar 4, 2020, at 7:05 AM, Igor Osmolovskiy  wrote:
> 
> 
> Hello
> pls see my response to Jim with the code sample
> 
> вторник, 3 марта 2020 г., 21:06:27 UTC+1 пользователь pfalson написал:
>> 
>> Can you post some code?
>> 
>> Sent from my iPhone
>> 
 On Mar 3, 2020, at 11:19 AM, Igor Osmolovskiy  wrote:
 
>>> 
>>> Dear all
>>> 
>>> I need the jBase DP (data pointer) to be initialized. I've actually managed 
>>> to initialize it by calling the jbase_getdp(). But in both cases the new 
>>> child session is created in jshell (and gets removed automatically after 
>>> the code has been executed).
>>> 
>>> So I am wondering: is there a possibility to retrieve and use the current 
>>> session DP somehow? So that no child session would get created
>>> 
>>> Any advice would be highly appreciated
>>> 
>>> Thanks in advance
>>> 
>>> 
>>> PS: to the admin, it is actually a jBase related question rather than TAFC. 
>>> Thanks
>>> 
>>> 
>>> Kind regards,
>>> Igor
>>> -- 
>>> -- 
>>> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>>>  
>>> 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
>>> 
>>> --- 
>>> You received this message because you are subscribed to the Google Groups 
>>> "jBASE" group.
>>> To unsubscribe from this group and stop receiving emails from it, send an 
>>> email to jb...@googlegroups.com.
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/jbase/73153581-25ae-493a-95f6-8afc5cdf7813%40googlegroups.com.
> 
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/5c46377f-4c68-4f50-a5fb-9d1d8164232b%40googlegroups.com.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jbase/E058F46A-17E6-4F97-9A47-3974BBC1EF1D%40gmail.com.


Re: Getting the jBase DP (data pointer) of the current session when using pure C

2020-03-03 Thread Peter Falson
Can you post some code?

Sent from my iPhone

> On Mar 3, 2020, at 11:19 AM, Igor Osmolovskiy  wrote:
> 
> 
> Dear all
> 
> I need the jBase DP (data pointer) to be initialized. I've actually managed 
> to initialize it by calling the jbase_getdp(). But in both cases the new 
> child session is created in jshell (and gets removed automatically after the 
> code has been executed).
> 
> So I am wondering: is there a possibility to retrieve and use the current 
> session DP somehow? So that no child session would get created
> 
> Any advice would be highly appreciated
> 
> Thanks in advance
> 
> 
> PS: to the admin, it is actually a jBase related question rather than TAFC. 
> Thanks
> 
> 
> Kind regards,
> Igor
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/73153581-25ae-493a-95f6-8afc5cdf7813%40googlegroups.com.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jbase/CBAA340C-20E0-405C-ACC5-948C232B1CD6%40gmail.com.


Re: jBASE EVAL Help?

2020-01-10 Thread Peter Falson
Add an AS  before your =

> SELECT X WITH EVAL "BALANCE LT QUANTITY" AS balLTqty = "1"
> 
Sent from my iPhone

> On Jan 10, 2020, at 1:29 PM, Joyce White  wrote:
> 
> 
> Thanks, pfalson! My use of it is more in a query, like below:
> SELECT X WITH EVAL "BALANCE LT QUANTITY" = "1"
> SELECT X WITH EVAL "BALANCE LT QUANTITY" = 1
>It seems like it's just evaluating for true/false, and expecting 1/0 as 
> the response. But I ran into a few curious things.
> 1) If I put quotes around the "1", it brings back all that are true.
> 2) If I DON'T put quotes around the 1, it brings back only the ones with a 
> difference of 1but it also brings back the ones where both are 0.
> 3) If I use 2 at the end, I get the following:
> Balance.  Quantity
> 14
> 12
> 00
> 
> 4) It doesn't seem to work with any other numbers at the end. Brings back 
> nothing.
> Can you explain exactly HOW it is evaluating? I'm just curious.
> Thanks!
> Joyce
> 
>> On Thursday, January 9, 2020 at 4:38:11 PM UTC-5, pfalson wrote:
>> EVAL “expression” [as alias] 
>> 
>> eg. LIST myfile EVAL "@ID[1,3] AS FIRST_THREE
> 
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> To view this discussion on the web visit 
> https://groups.google.com/d/msgid/jbase/9bf7c3e0-6358-4be0-afb3-cf33811004be%40googlegroups.com.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/jbase/C001E941-66D9-46CC-AA01-DF03980AE095%40gmail.com.


Re: Create-file question

2018-11-16 Thread Peter Falson
Get rid of the " around the \FILENAME \

Sent from my iPhone

> On Nov 16, 2018, at 11:25 AM, Marc  wrote:
> 
> I'm trying to EXECUTE a CREATE-FILE command  as shown below and I'm obviously 
> screwing up the punctuation...
> 
> FILENAME = VNAME:".PRICE"
> OPEN ''",FILENAME TO F.OUT ELSE
>  EXECUTE \CREATE-FILE DATA "\:FILENAME:\"\ 11\
> OR
> 
> EXECUTE \CREATE-FILE DATA "\:FILENAME:\" 11\
> 
> What am I doing wrong??
> 
> Thanks!
> 
> -- 
> -- 
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>  
> To post, send email to jBASE@googlegroups.com
> To unsubscribe, send email to jbase-unsubscr...@googlegroups.com
> For more options, visit this group at 
> http://groups.google.com/group/jBASE?hl=en
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to jbase+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

-- 
-- 
IMPORTANT: T24/Globus posts are no longer accepted on this forum.

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

--- 
You received this message because you are subscribed to the Google Groups 
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to jbase+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.