Results 1 to 12 of 12
  1. #1
    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...

  2. #2
    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.

  3. #3
    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.

  4. #4
    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.

  5. #5
    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.

  6. #6
    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.
    Last edited by rockingred; 01-31-08 at 10:22.
    When it rains, it pours.

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

  8. #8
    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.

  9. #9
    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.

  10. #10
    Join Date
    Jun 2012
    Posts
    1
    Manda7

    Kinldy see a post i did to you. I have a consultancy for jbase on t24

  11. #11
    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. . .

  12. #12
    Join Date
    Jan 2013
    Posts
    1
    hi am new to JBASE programming but need to learn it, hope i'll get help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •