Recent content by question911

Crystal 9 Need a counter variable to start at 902 instead of 0. Does anyone know how to do this? My formula looks like this WhileprintingRecords; NumberVar counter; If not isnull(GroupName ({SERVICE.START_TIME}, "by hour")) Then counter := counter + 1

I added a call in my shell script to reference the profile file. I also, still had to add ksh to my CRON task schedule. If I didn't add ksh, it would not run. Weird. . /etc/profile Thanks everyone!

Eric, What do u mean by source your oraenv?

Hi Alexhu, I tried it without the "sh" in front of it. I still get the same result. It doesn't run.

sqlldr pro/pro control=/home/pro/dataload.ctl log=loadgood.log bad=loadbad.log

SC0 7.1 CRON schedules jobs correctly, except for one. Below is the problem entry. Also, below is the CRON log file. There is no problem executing this from the command line manually. #Load Table 25 11 * * * sh /data/loaddata.sh CMD: sh /data/loaddata.sh > root 10904 c Tue Feb 1...

Thanks for feedbacks. I used Access to link the two tables and created a query to perform inserts. Man, it would take 4 hrs to complete the job. Does anyone know if ADO is being used when using an Access query to perform an insert? One of the reason I preferred avoiding using sqlldr was my...

Do you have sample code to loop through the recordset to insert into Oracle table? This sounds like it would take forever to insert 200,000 records.

How would the code like if I needed to get the results from the first database to the second database. For example I can get the recordset from my MS SQL databse, but how do I pass these records over to the Oracle connection to perform an insert of these records?

Get External Data --> Link Tables

What you want require third party IDE. You can use VB, ADO, T-SQL, and Crystal.

8.5 has this feature.

In the "Change Group Options" window, select the "Common" Tab". In the Common Tab, select "In Specified Order." In the "SPecified Order" Tab, select the account numbers you will always need to group by. In the "Others' Tab, select "Discard All Others."

Usually these ODBC drivers like IBM Informix drivers allow you to specify a generic logon id and password to use by adding it to the windows registry.

Yes, I use conditions in my selection formulas.