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