Search found 92 matches
- Mon Sep 09, 2013 11:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: APT_CHECKPOINT_DIR
- Replies: 2
- Views: 2745
APT_CHECKPOINT_DIR
Whats the default value we need to set to APT_CHECKPOINT_DIR
- Tue Jun 11, 2013 10:21 am
- Forum: General
- Topic: installation 8.0 version
- Replies: 2
- Views: 1670
installation 8.0 version
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
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
- Fri Apr 05, 2013 7:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: sql help
- Replies: 6
- Views: 3459
- Thu Apr 04, 2013 2:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: sql help
- Replies: 6
- Views: 3459
sql help
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
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
- Sat Mar 16, 2013 8:14 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: overwritting all .dat,.ctl,.bad,.log file
- Replies: 2
- Views: 2013
overwritting all .dat,.ctl,.bad,.log file
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
- Mon Feb 04, 2013 1:15 pm
- Forum: General
- Topic: sql script
- Replies: 1
- Views: 1222
sql script
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?
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?
- Tue Jan 29, 2013 1:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: spaces
- Replies: 1
- Views: 1570
spaces
when we load data into oracle tables.
Do we need to trim spaces
Thanks
Do we need to trim spaces
Thanks
.dsx file
I opened the .dsx file with notepad, icon changed to notepad. How to revert back to original icon
- Wed Dec 19, 2012 2:35 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: difference between two rows
- Replies: 7
- Views: 3895
- Wed Dec 19, 2012 2:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle sequence for getting the value
- Replies: 11
- Views: 6279
- Fri Dec 14, 2012 2:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: difference between two rows
- Replies: 7
- Views: 3895
- Fri Dec 14, 2012 2:12 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: difference between two rows
- Replies: 7
- Views: 3895
- Fri Dec 14, 2012 1:22 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: difference between two rows
- Replies: 7
- Views: 3895
difference between two rows
How to get difference between two rows for a column field?
ex:
ex:
Code: Select all
rowInt Value
99 0
98 1
97 10
96 0
- Fri Dec 07, 2012 10:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle sequence for getting the value
- Replies: 11
- Views: 6279
- Thu Dec 06, 2012 3:49 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle sequence for getting the value
- Replies: 11
- Views: 6279