If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > New Members & Introductions > JBASE Programming

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Jan 2008
Posts: 3
Question JBASE Programming

hello to everyone:

I want to learn to program in JBASE...Anyone who can provide me with help like materials, basic programming tutorials etc...I would truly appreciate it.

I need the skill because I just got a new job that would give me a good edge if I knew JBASE programming.

I hope to hear from anyone. You can email me as well. Thank you...
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Toronto, Ontario, Canada
Posts: 203
If you can program in Basic you can program in jBASE, they're pretty much the same. For specific verbs / functions unique to jBASE, check out their website "Knowledgebase":

jBASE Knowledgebase

Beyond that, I find the "Pick Pocket Guide" to be one of the most usefull programming tools. It's well structured and has most verbs common to all Pick type systems.
__________________
When it rains, it pours.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Jan 2008
Posts: 3
jbase programming

Rockingred:

Thank you for your response. It's a great help. Are you still looking for work? Why not look for one in the banks that use JBASE as their database. Temenos Banking system clients use JBASE and I know they have a lot of job openings. Are you based in Europe, UK specifically. Finding a job will not be problem if you know jbase.
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Toronto, Ontario, Canada
Posts: 203
Unfortunatly I'm in Toronto, Ontario, Canada and there doesn't seem to be much call for jBASE programmers here (if I were in California I think I would have no problem finding a good career position).

Another thing to note about jBASE (Pick) type systems is the level of ability to access information.

For example, if you have a file called CUSTOMER and another called INVOICE, each would have it's own unique ID's for their data. In the INVOICE file you would have a field for Customer ID and you could set up Function Correlatives in the INVOICE file to read information over from the CUSTOMER file (without storing the data in two different places). Likewise in the CUSTOMER file you can have a multi-valued field for INVOICE numbers and use that to reference all the fields stored in the INVOICE file, through F/Correlatives.

That's just the starting point. Then there is the "Terminal Control Language", usually referred to as TCL but also sometimes called Tickle. If you know the name of a file and the names of the field within the file, then you can generate simple reports from TCL:

SORT CUSTOMER WITH BAL.OWE > "0" BY NAME CUST.NO NAME ADDR1 ADDR2 CITY PROV POSTAL.CODE PHONE.NO BAL.OWE ID-SUPP (P

The above statement would give a list of any customers in the file with a balance owing greater than zero, in order by their name, showing the Customer Number, Name, Address Line 1, Address Line 2, City, Province or State, Postal or Zip Code, Phone Number and Balance Owing. The ID-SUPP is usually used because you want to suppress the default ID format in favour of a different format that you have included in your statement (in this case CUST.NO). The (P option sends the report to a printer instead of displaying it on the screen.

Then there are the PROC (standard procedures) that may be set up. Basically, anything that can be typed at TCL can also be set up into a PROC that would allow repetitive simple reports to be generated without having to remember all the fields each time. For example, the above report could be included in a PROC called "OUTSTANDING.CUSTOMER" and each time you need to run it you would simply type OUTSTANDING.CUSTOMER at TCL.
__________________
When it rains, it pours.
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Jan 2008
Posts: 3
Rockingred:

I heard from a friend in Toronto that Software Testers are paid big money there. Which software in particular would that be.

I wish you can find yourself a job there soon. Best wishes for you.
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Toronto, Ontario, Canada
Posts: 203
Haven't heard that one, and without knowing the company it's hard to follow up on. But thanks. Good luck to you, I hope you enjoy using jBase.

You may also be interested in checking out some of the books provided by http://jes.com/picklist.html

One of the most usefull is the Pick Pocket Guide. I've owned two or three by now, I use them until the covers come off and then buy a new one.
__________________
When it rains, it pours.

Last edited by rockingred; 01-31-08 at 10:22.
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Feb 2008
Posts: 2
Hi there,
Im also very much looking for work.But the problem is that im based in Kenya.
Is it possible to get a job there, UK, while being Kenya.
I ahve enough experience with jBASE and all Temenos products including T24.
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
Join Date: Feb 2008
Posts: 2
a transaction details

Hi there,

Im using jbase on Temenos T24

1. kindly assist me with a program that extracts all details of a transaction.I mean the account nimber, ref., customer name. cheque no. amount, et.c
In jBASE, so that i will just run the program and it gives me the output on the screen.

2. Assist me with a program that can resize all files including the history files in jbase.
Reply With Quote
  #9 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Toronto, Ontario, Canada
Posts: 203
1. First you'll need to find out the name of your Transaction file, once you have done that you can sort the dictionary of the file to find out the names of all the fields

SORT ONLY DICT filename BY *A2 BY *A7 BY *A8 *A0 *A2 *A3 *A7 *A8 ID-SUPP

(*A## are usually set up on every system in the MD as quick references to attributes zero through ten. However if they haven't been set up you'll want to set them up. I usually set up my own version of each in the MD for dictionaries as follows:
DICT.ID = Left justified for 10 characters version of *A0 (Dictionary ID)
POS = Right justified for 3 characters version of *A2 (attribute 2 of a dictionary usually stores the position in the file),
PROMPT = Left justified for 20 characters version of *A3 (attribute 3 of a dictionary is usually the prompt or column heading that appears on reports),
VCONV = *A7 for 4 characters (attribute 7 usually stores conversions),
VCORR = *A8 for 10 characters (attribute 8 usually stores correlatives and translates),
VJUST = *A9 for 1 character (attribute 9 usually stores the justification),
VLEN = *A10 for 3 characters (attribute 10 usually stores the length of the field)

Once you have gotten the list of the dictionary items you want from the file, then you can build your report. Will it be the same every time or are their prompts that you want to ask the user? How do you intend to narrow down the scope of your report to only show recent items or important items instead of all items?

Regarding #2, first you'll need to find out if LIST-FILE-STATS or some similar command exists on your system. Once you know that you can see where those statistics are stored and use that to write your program. Please remember, resizing files SHOULD NOT occur when people may be using those files. You'll probably only want to do it once a month on a weekend. You also have to decide how to handle files that get emptied on a regular basis (temporary files) and write your program to keep that in mind. (I would recommend having a record in a control file that contains a list of files that should not be downsized or resized)
__________________
When it rains, it pours.
Reply With Quote
  #10 (permalink)  
Old
Registered User
 
Join Date: Jun 2012
Posts: 1
Manda7

Kinldy see a post i did to you. I have a consultancy for jbase on t24
Reply With Quote
  #11 (permalink)  
Old
Registered User
 
Join Date: Oct 2009
Location: 221B Baker St.
Posts: 487
You do realize you have replied to a topic that has been dormant for more than 4 years. . .
Reply With Quote
  #12 (permalink)  
Old
Registered User
 
Join Date: Jan 2013
Posts: 1
hi am new to JBASE programming but need to learn it, hope i'll get help.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On