Recent content by EdWall

I suggest that you use an Outer Join on from table A to Table B and limit the records retrieved so that you don't fill up the rollback segment. Then loop round the records in Table A and delete the associated reference records. DECLARE CURSOR del_cursor SELECT A.pk, A.ROWID FROM a, b WHERE...

To load into multiple tables, you could use a when clause in your SQL-Loader control file if you have a fixed format file as in the example LOAD DATA INFILE 'daily.dat' REPLACE INTO TABLE prices WHEN (12:17 = 'EUSCAN') TRAILING NULLCOLS ( PROD_CODE POSITION(01:04) CHAR...

You can use ROWNUM in your query as follows SELECT ... WHERE ROWNUM <= 5 There is a recent thread on this subject in this forum which I will try to locate... Ed

According to the PowerBuilder Documentation, this doesn't seem to need any conversion. The only warning the documentation gives is to state that the AutoCommit property of the transaction object should be set to True for both the DBMSs that you mention. Are you getting a compilation error? Ed

Eugenio, I think you have to give a little more information than you have done. You just need to use the same connection details in the two applications. Ed

Keith, this is not a Powerscript function - it is a DataWindow function. Try Integer() or Long() instead. Ed

If there are other indexes on the table, these might be detrimental to performance because the indexes have to be updated after each delete. You could remove these before deleting and then recreate them afterwards. It might be worth considering recreating the date index after each deletion too...

To update this data as a one off, why don't you: Create a sequence Write a pl/sql block which loops through the records in the table extracting the primary key. Within the loop, update the id column with the nextval of the sequence using the primary key of the row.

Gert, have you tried using something other than SYSDATE in your insert statement or omitting this column. This is a guess but it is a difference between your successful insert and the one which doesn't work. Ed

tendo, why don't you have 3 separate fields instead and place them exactly where you want to? Ed

Hi Smilee for question 2) have you looked up details for SQL-Loader. There are a lot of options but you will only need basic ones to be able to load up a table from a tab-delimited or CSV file. Check out the oracle documentation or even sqlldr help initially. Here is a quick example of a...

If you are using SQLPlus, you can type ed to use the system editor which is dependent on the Operating System e.g. Notepad. You don't say whether you are using SQLPlus

This will not quite work because the syntax is not exactly correct. You don't really want a COUNT here, you want the department no and to know if the employee cannot be found. I suggest you do it like this: BEGIN select dept_no INTO v_deptNo from employee where empname = p_empname...

I suggest that you take care in using a sequence in this way because a sequence's auto-increment is not associated with a transaction at all so that the nextval of the sequence will be incremented even if the transaction containing the update to the department table is not committed for whatever...

I am not sure exactly what your context is but the following might help From Excel, you can export the data in tab-delimited format on a per table basis for the target database. In the PowerBuilder IDE, open the Database painter and the tables into which you want to import the data. Choose...