Search results for query: *

Is this compatible with Oracle? Can you embed sql?

Thank you for everyone's input. I lucked out and the customer sent me a decent comma-delimited file that made it a snap!

mrregan wrote: From the zip code file, get the city name and unstring your data into two fields with the city name as a delimiter. The first field should wind up as the street address. Note: you probably want to convert everthing to upper or lower case in both your data and the...

Great idea Mrregan! Now I have zip and addr2, just have to figure out how to get addr1 w/o a delimiter. 123 main st or PO BOX 23432 CASA GRANDE AZ 85122.

That's a great idea. Now I will only need to unstring the address, which will still take some work since, I do not have a delimter.

It is only US addresses and I have a list of all of the possible 2 word cities. Not sure how the unstring would work becuase there is not any kind of delimiter. I am reading backwards and have stripped out zip and state so far. Now I am at city.

Sorry I meant incoming address field is 50 bytes long.

I have a program where the incoming address file is 50 bytes long. The problem is there is no delimiter other than space. 123 main st Orlando fl 30992 or PO BOX 23432 CASA GRANDE AZ 85122. I need to move 123 main st to addr1, orlando fl addr2 and 30992 to zip. I figured out how to get the zip...

I have a program that I wrote that creates a work file to read from to create a print record. The program is a sales report that allows the user to specify how many years to compare. An example is 07-01-06 thru 07-31-06 If they answer 3 prior years it would show sales data (it also handles exact...

Thanks, I have a 500 page .pdf, I guess I was looking for better examples, or maybe I can paste some code and see an exampl eof how to fix it. I just need to get the ball rolling. I appreciate your help.

I have been programming Cobol for a while, but have never used embedded sql in Cobol and am fairly new to SQL. The company I work for now is using a middleware to go in between MF Cobol and Oracle and are wanting to get rid of the middleware and embed SQL or PL/SQL in the code. DOes anyone have...

My company is currently using QCTerm as a unix emulator, when I try to run the anim command (animate command in MF Cobol) it works, but I am not able to use important function keys like F4 to monitor. If I press function keys the session just freezes and I have to do a hard reset from the QCTerm...

We are in the process of a huge conversion project and we keep finding little bugs on the MF-Cobol HP9000 side. For instance Reports are ok except the totals are off. It seems like an initialization problem, but I do not see anything obvious. I've been told MF Cobol is very strict in...