DSXchange

Whats the default value we need to set to APT_CHECKPOINT_DIR

when installing 8.0 version

Installation is stopping at 52%

Domain component installer action

An error occurred installing the domain component, for more info see the log file.

Any help to resolve this error

Thanks

Oracle sql

select count(*),BookNbr
from tablename
where BookNbr like '0%'
group by BookNbr asc
;

0012
0013
0014
0015
0112
0113
0114
0115
0212
0213
0214
0215

How can i get the top 3 records from each group .depending on first 2 positions of BookNbr

Thanks in advance

I need to run a server job with sqlldr twice with different source file. When job1 runs it create .dat,.ctl,.bad,.log file When job2 run it is overwritting all .dat,.ctl,.bad,.log file How to handle this situation? I can simply rename the file names., But i don't want to do that. Any help to handle it

I did create a sql script to get the counts, delete records from database.

I am running the test.sql from Oracle SQL*Plus. Its taking a long time to run the script.

There is no commit in the sql script.

How can i stop the script?

when we load data into oracle tables.

Do we need to trim spaces

Thanks

I opened the .dsx file with notepad, icon changed to notepad. How to revert back to original icon

Chulett your suggestion works for me thanks for the help.

Created oracle sequence, used seq.next value

Thanks for the help

I am in the process of reading sqlldr log file

skipped 0
read 10
rejected 1
discarded 0

so i need to compute the records loaded. Thats the background :D

thats the input

rowInt Value
97 9

How to get difference between two rows for a column field?

ex:

The nextvalue will only get incremented when records is inserted into database

So that means insert should follow for each record

Then the nextvalue will get incremented by 1


is this a true statement

I am extremely sorry for typing in the wrong info :oops: Here is the job design For a every record in the source if there is a corresponding match in the lookup then we pick the id from that lookup. else we should get the next value from oracle sequencer. For each and every record Thanks in advance