Hi,
Varchar2 is for that,it save spaces.
For example "DataStage " will store as "DataStage".
Why you want trailing blank spaces in your target table?
regards
kcs
Search found 89 matches
- Wed Mar 08, 2006 4:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: trailing spaces getting trucated.
- Replies: 5
- Views: 2812
- Tue Mar 07, 2006 7:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS Server Restart
- Replies: 8
- Views: 5098
Hi, Sorry for responding late. After we got user2 7623 Sep12 .......FIN_WAIT_1 . we restarted the server. When we check for netstat -na |grep 31538 ,it returned nothing. DS is working fine now. Did you check to see whether pid 7362 had any child processes before you killed it? Killing a parent can t...
- Sun Mar 05, 2006 7:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS Server Restart
- Replies: 8
- Views: 5098
Hi Kumar,Craig Thanks for your reply. We exeute ps -fe | grep dsapi_slave | more to find the process id of this connection. we got user2 7623 Sep12 .......ESTABLISHED. We kill that process(7623) through root. When we execute netstat -na |grep 31538,we got user2 7623 Sep12 .......FIN_WAIT_1 . Does it...
- Sun Mar 05, 2006 1:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Trial balance and balance sheet amount validation
- Replies: 4
- Views: 3109
Hi Parag, Now i have to device a logic such that if i am running a job in Feb end then the amount for feb should be difference of feb amount and previous month i.e. jan amount (Feb Amt - Jan Amt). Is it always the difference between the current month and the previous month? ie is this logic applicab...
- Sun Mar 05, 2006 12:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DS Server Restart
- Replies: 8
- Views: 5098
DS Server Restart
Hi, We want to Restart the DS Server. We know that everybody has logged out. When we execute netstat -na |grep 31538 command, we found that one user is still connected to DS. tcp XXXXX 100.200.20.30 100.200.10.15.1740 .....ESTABLISHED . Iam sure that nobody is using 100.200.10.15. How is it possible...
- Sat Mar 04, 2006 1:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Most Recent record from a sequential file
- Replies: 2
- Views: 2014
- Wed Mar 01, 2006 4:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Schedule Date for Sales Order
- Replies: 2
- Views: 2365
- Sat Feb 25, 2006 3:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to set different values forsamecoloumn in different rows
- Replies: 12
- Views: 6205
- Thu Feb 23, 2006 12:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel job reports failure (code 1) Job failure
- Replies: 2
- Views: 2189
Hi Nick,
After Searching the forum for Parallel job reports failure (code 1),I got this linkviewtopic.php?t=92186&highlight=reports+failure.
regards
kcs
After Searching the forum for Parallel job reports failure (code 1),I got this linkviewtopic.php?t=92186&highlight=reports+failure.
regards
kcs
- Tue Feb 21, 2006 1:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Iconv Oconv
- Replies: 7
- Views: 3683
- Fri Feb 17, 2006 5:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date check for business validation
- Replies: 14
- Views: 7484
- Thu Feb 16, 2006 1:43 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine - Code not visible to anybody
- Replies: 9
- Views: 6125
Hi, Search the forum for Creating a secure routine .That post will elaborate(By Ray) on You can create routines as external UniVerse routines, globally catalog them and create interludes to them. This is a lot of work, probably for no great gain. And will it work once DataStage is no longer based on...
- Thu Feb 16, 2006 12:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine - Code not visible to anybody
- Replies: 9
- Views: 6125
- Wed Feb 15, 2006 11:57 pm
- Forum: Site/Forum
- Topic: 10K topics in Server Edition
- Replies: 0
- Views: 2599
10K topics in Server Edition
Congrats DSX, on reaching yet another milestone.
regards
kcs
regards
kcs
- Tue Feb 14, 2006 6:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error 81016 - conn was refused or RPC daemon not running
- Replies: 3
- Views: 2730