Since you have enclosed with in double quotes and assuming you have done this setting in your Seq file as well (i.e. anything enclosed with in double quotes as a one column value).
Now you can read the first column as a varchar and remove any comma's and load the data into the oracle object.
thanks!
Search found 18 matches
- Mon Jun 14, 2010 3:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: data conversion problem
- Replies: 28
- Views: 28782
- Thu Nov 26, 2009 12:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to get file from another Server
- Replies: 22
- Views: 9480
- Thu Nov 26, 2009 12:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need to get file from another Server
- Replies: 22
- Views: 9480
Thank you all, I gone through the manual and i searched in DSX for the FTP plugin details, I tried to work through it, Now i have some queries, Can i connect to the local machine i.e.,Localhost,? If so, What is the properties that has to be set as mandatory? I am having a 3GB file in my desktop of ...
- Thu Nov 26, 2009 12:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to handle reject in Join
- Replies: 5
- Views: 7878
- Thu Mar 05, 2009 1:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COncatenation with blank values
- Replies: 10
- Views: 4693
Re: COncatenation with blank values
fristname-->GIRI
lastname--->KIRAN
fristname:' ':lastname
dont give any spaces in between and then try, it is working for me.
lastname--->KIRAN
fristname:' ':lastname
dont give any spaces in between and then try, it is working for me.
- Thu Mar 05, 2009 1:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: COncatenation with blank values
- Replies: 10
- Views: 4693
Re: COncatenation with blank values
fristname-->GIRI
lastname--->KIRAN
fristname:' ':lastname
dont give any spaces in between and then try, it is working for me.
lastname--->KIRAN
fristname:' ':lastname
dont give any spaces in between and then try, it is working for me.
- Fri Nov 28, 2008 4:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: To Add Header and Footer to the Sequential File
- Replies: 3
- Views: 5897
Re: To Add Header and Footer to the Sequential File
Hello,
if your triggering your job through UNIX script then easily you can do this task with in shell script.
Ex:
echo " filename date +ymdhms">file.dat # before triggering job
wc -l<file.dat >>file.dat # once job is done.
Thanks,
Waseem
if your triggering your job through UNIX script then easily you can do this task with in shell script.
Ex:
echo " filename date +ymdhms">file.dat # before triggering job
wc -l<file.dat >>file.dat # once job is done.
Thanks,
Waseem
- Fri Nov 28, 2008 4:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to call stored procedure having only IN parameter in DS
- Replies: 7
- Views: 23640
Re: how to call stored procedure having only IN parameter in
Hello, My understanding says u want to provide a input value and get the output records it means you want to send record to SP stage and get the records from SP stage, if so then make the procedure type (comes under syntax tab) as Transform so that u make it to send and receive the records. Thanks, ...
- Fri Nov 28, 2008 3:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to call stored procedure having only IN parameter in DS
- Replies: 7
- Views: 23640
Re: how to call stored procedure having only IN parameter in
Hi,
You can use Stored Procedure stage, Use SP stage as transform stage so that you can provide Input values and get output values.
thanks,
Waseem
You can use Stored Procedure stage, Use SP stage as transform stage so that you can provide Input values and get output values.
thanks,
Waseem
- Tue Nov 25, 2008 4:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Checking files on Remote server
- Replies: 2
- Views: 2108
Re: Checking files on Remote server
Hi Deepti, u can do it through Shell script, I had the similar situation. login into ur remote server as telnet ####################Code#################### ( echo USERID; sleep 2; echo PWD; sleep 2; echo "rm FILE_PATH/filename"; sleep 2; )| telnet SERVER_NAME>log.txt OR if you want to loo...
- Thu Aug 21, 2008 1:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Funnel different Meta Data
- Replies: 2
- Views: 2252
Re: Funnel different Meta Data
Hi,
Table1: c1, c2, c3, c4
Table2: c1,c2,c3
Table3: c1,c2
select c1, c2, c3, c4 from Table1
select c1, c2, c3, 'T2C4' as c4 from Table2
select c1, c2, 'T3C3' as c3, 'T3C4' as c4 from Table3
After funnel you can set NULL values/any desired values in those columns using transformer.
Thanks,
Waseem
Table1: c1, c2, c3, c4
Table2: c1,c2,c3
Table3: c1,c2
select c1, c2, c3, c4 from Table1
select c1, c2, c3, 'T2C4' as c4 from Table2
select c1, c2, 'T3C3' as c3, 'T3C4' as c4 from Table3
After funnel you can set NULL values/any desired values in those columns using transformer.
Thanks,
Waseem
- Thu Aug 21, 2008 1:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: IsNotNull function not working fine for me
- Replies: 10
- Views: 3912
Re: IsNotNull function not working fine for me
Hi,
Please can you use diffrent Trim functions of datastage.
like TrimLeadingTrainling(), just try with this option.
Thanks,
Waseem
Please can you use diffrent Trim functions of datastage.
like TrimLeadingTrainling(), just try with this option.
Thanks,
Waseem
- Thu Aug 21, 2008 12:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dividing an integer
- Replies: 15
- Views: 8847
Re: Dividing an integer
Hi,
if you are using this operation "Div(AsFloat( DSLink3.INSTR_SET_HRS), AsFloat(10)", then it will return only the whole part of a number.
Use the below function and try.
AsFloat(AsFloat(DSLink3.INSTR_SET_HRS)/AsFloat(10.0))
Hope this work will.
Thanks,
Waseem
if you are using this operation "Div(AsFloat( DSLink3.INSTR_SET_HRS), AsFloat(10)", then it will return only the whole part of a number.
Use the below function and try.
AsFloat(AsFloat(DSLink3.INSTR_SET_HRS)/AsFloat(10.0))
Hope this work will.
Thanks,
Waseem
- Wed Aug 13, 2008 11:24 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to get Max(DATE) using transformer
- Replies: 16
- Views: 15363
Re: how to get Max(DATE) using transformer
Hi, Map the value like this outlink.field01 ==> StageVar1 if StageVar1=StageVar2 then 'R' else 'P' StageChkVar outlink.field01 ==> StageVar2 In Transformer Constraints, u can have condition as StageChkVar='P' Other Simple Way would be have a remove duplicate stage Sort data based on first by field01...
- Mon Aug 11, 2008 1:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Every Run date and time should change
- Replies: 5
- Views: 2883
Re: Every Run date and time should change
i have developed parallel job for the replace load where one of the output Archeive filename must have prefix Date and time how to acheieve.So for every run Date and time must change and it must overwrite(For eg:<Path><date&timefilename.dat>) and frequency of load is daily. In UNIX: if you are ...