Hi All,
My requirement is very simple. I 've one oracle table as source, which is having one column with data type as BLOB and this column is storing images. Now I need to read this column using Datastage and FTP this images to my UNIX server as image files.
Can anybody help me to solve this?
Search found 21 matches
- Tue Jun 03, 2008 9:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Reading and FTPing BLOB using datastage
- Replies: 1
- Views: 1239
- Sat Apr 12, 2008 6:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle commit interval
- Replies: 11
- Views: 7813
- Sat Apr 05, 2008 11:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle commit interval
- Replies: 11
- Views: 7813
- Thu Apr 03, 2008 12:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Restart Datastge Services failed
- Replies: 3
- Views: 1841
- Thu Apr 03, 2008 10:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Restart Datastge Services failed
- Replies: 3
- Views: 1841
Thanks ArndW for the prompt reply. I am using dsadm user id. My dspx00 directry is full. Please find the dbf command output, /dev/vgDStage/lvol1 62914560 62914560 0 100% /dspx00 And when I am doing a netstat -a | grep dsrpc I am getting one connection as ESTABLISHED. tcp 0 0 hpus40.dsrpc 172.29.30.2...
- Thu Apr 03, 2008 10:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Restart Datastge Services failed
- Replies: 3
- Views: 1841
Restart Datastge Services failed
Hi All, I stopped the datastage services using the command uv -admin -stop . But when I am trying to restart services after a few minutes, its showing an error as follows chmod: can't access /dspx00/Ascential/DataStage/DSEngine/dstmp.080403.185943B I serached for the file dstmp.080403.185943B in /ds...
- Sun Mar 30, 2008 3:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Gregorian Date to Hijri
- Replies: 2
- Views: 1326
Gregorian Date to Hijri
Hi All,
In my job, the input is Gregorian date, I want to convert it into corresponding Hijri date. Can anybody suggest a method to do this.
In my job, the input is Gregorian date, I want to convert it into corresponding Hijri date. Can anybody suggest a method to do this.
- Thu Mar 27, 2008 4:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle commit interval
- Replies: 11
- Views: 7813
- Wed Mar 26, 2008 7:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How do I find garbage/control characters within a column?
- Replies: 8
- Views: 3530
- Wed Mar 26, 2008 5:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle commit interval
- Replies: 11
- Views: 7813
- Wed Mar 26, 2008 3:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle commit interval
- Replies: 11
- Views: 7813
- Wed Mar 26, 2008 1:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle commit interval
- Replies: 11
- Views: 7813
Oracle commit interval
Hi All, Good Morning. I 've an issue while using the two environment variables APT_ORAUPSERT_COMMIT_TIME_INTERVAL and APT_ORAUPSERT_COMMIT_ROW_INTERVAL. In my job I am upserting (update first and insert) data into an oracle stage. My requirement is, I 've to commit records after each insert/update. ...
- Sat Mar 15, 2008 11:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reject records with referential integrity constraint
- Replies: 14
- Views: 6471
- Thu Mar 13, 2008 8:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reject records with referential integrity constraint
- Replies: 14
- Views: 6471
- Thu Mar 13, 2008 7:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reject records with referential integrity constraint
- Replies: 14
- Views: 6471
Hi Ray, Thank u for ur reply. But why u r saying rejecting records in the target will never be a better solution? Will it slowdown the job. Since I am inserting 33 million records into target, in that records only 60 records are violating parent key constrain. So to identify this 60 record I am perf...