Search results

Unless someone else has other ideas on how I should change this script, I guess I have to put this all on hold for a while. The UNIX guy responded to my "COMPILE yourprog.p XREF yourprog.xrf" request with: So...for now I will continue to use the flat file that I'm currently getting. In SQL...

Yes, quite right. But it is better than it was. It took about 10 tries to get my first script to run and produce a text file. The UNIX guy was quite fed up with me and suggested that we hire someone to do the scripts. I don't know - to all three! Anyway, thanks for your help today! I will...

How do I tell the UNIX guy to do a compile with XREF? Can I send him some code? Otherwise, he won't know what to do.

I'm sure there are better solutions than what we are doing, but for the time being, this is what I have. Almost 2 years ago, the computer running the Progress database crashed. It took several days for the IT dept to get it back up and running. All the .p scripts that ran daily to pull data...

Still running after an hour so the UNIX guy stopped it again.

I'm not really sure how to explain it. I'm learning as I go. I've got a picture in my mind of a UNIX box sitting next to the IT professional that I've been told is our UNIX guy. I don't know what his capabilities are, but I know he's not a Progress guy. I just know that if I send him a .p...

Hmm, greek to me. Not sure what you are asking. I work for a company that purchased this Progress based UNIX system a few years ago. We originally outsourced the "UNIX to SQL server" data warehousing component, but never really got the product we expected. Now, I'm trying to build the SQL...

:blush1: So, if I change it to: main-loop: FOR EACH BF.trips NO-LOCK WHERE BF.trips.sycom# = vipSycom#: FOR EACH BF.trips NO-LOCK WHERE BF.buys.sycom# = BF.trips.sycom# AND BF.buys.cust# = BF.trips.cust# then you think it will run faster?

Here's the whole script that I submitted this a.m. (execpt I shortened it and excluded the other 20 fields from the trip table that I want returned). I don't want any fields returned from buys, just the trips that were affected by any buys with a record change date in my range. Where should I...

Here are the indexes that I get from the data dictionary for these two tables: ============================= Table: buy ============================== Flags: <p>rimary, <u>nique, <w>ord, <a>bbreviated, <i>nactive, + asc, - desc Flags Index Name Cnt Field Name -----...

Well, the UNIX guy said the script had been running for about an hour, so I told him to just stop it. That's too long, even if it were to work. There's around 60,000 "buys" records in this period and only 4,000 "trips" records. There's a total of 19 million "buys" records in the entire table...

Thank you! :) I was getting discouraged with no reply when I left the office on Tuesday. I was off yesterday. I was so happy this a.m. to find a response with something I could try! I fixed my script and sent it off to the UNIX guy just now. Hope it works!

The question is (if I wasn't clear in my first post): What would the Progress code look like for this join? please,please,please?

I need to extract data from the UNIX system we have and populate a SQL server database. Every day my DTS packages import the flat files that are pushed to the SQL server and insert into or update the database for the past few days. I don't actually have access to the UNIX box, but instead...

Hi everyone! My name is Wendy and I'm new to Progress. I have a coding problem and need some help. I posted it in the Development section, please check it out. Any help would be tru-uly appreciated! Thank you so very much.