Search results for query: *

I am getting a file from a client which I assume is coming from a mainframe and is being transfered over to a unix box. I am running the file through sql-loader to populate an Oracle table. The field I am having a problem with is being moved to fields depending on which code it is. The position...

Wow, thanks for all your great feedback. I think I might have it figured out!

It seems I may need to unstring and then go back and inspect it. I need a good example of unstring using pointer and tallying. Since the data is never in the same format. I went to the page Glenn recommended but I cannot view the examples.

Glenn can you post a little pseudocode or an example.

Thanks, for getting back to me Glenn! When I go to that page I can't see the examples. Not sure why. I will search for unstring with pointers. Thanks!

I am working on a data conversion project and I am trying to find the zip in the field(s). It can be in adr3 or adr2 field and I have to figure out how to parse it out to a zip field. The problem is the data is not consistent. Here are some examples of what the data looks like. The input file is...

unfortunately with the job market the way it is, I have to ride this train for a little while. I agree with what you posted tho.

Santamufasa, I will post the W-S tomorrow morning. This program does not update any tables, it gets the fields it needs from the 3 tables, build s a sort-rec and then build a report-rec from the sort-rec. Not an ideal program to convert. We have 100's of these type programs. I was hoping since...

I agree 100% LKBrwnDBA. We have a lot of Cobol programs with embedded sql in them. They seem to be bound and determined to move away from Cobol. I think PL/SQL has its purpose, but I think we should just embed sql in some of these batch programs. I agree we will need some kind of temporary table...

The company is looking to do this in house w/o training. So I suspect it to be a slow process. The problem is the Cobol programmers have to learn this while they are still working on there daily Cobol work.

Thank you SantaMufasa. For the moment I am going to keep the displays/accepts that Cobol handles. Unless you know of a better way. The program is the typical batch Cobol program. init-routine (displays/accepts), sort routine, return sort creates report. I tried to pair it down as much as...

Does anyone have experience converting Cobol programs to PL/SQL? I am having a hard time getting started and was hoping maybe someone had an example Cobol program they had converted. Any help would be greatly appreciated. Thank you!

I have a logo (bitmap) that I want to send to a datamax printer for the top of a label. Pretty new to datamax label printers. If I have the bmp on my computer in the data directory. Not sure how to accomplish getting this on the label. Should I create an indexed file with the .bmp as the field...