Search found 186 matches
- Sun Oct 23, 2016 12:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help required in logic
- Replies: 5
- Views: 5551
In aggregator I have given acct_number, tins and soa for grouping keys and in aggregation acct_status (determine open/closed) I have columns acct_status, acct_number, tins and soa in the source Query and I need acct_number, tins and soa in the output. Every acct_number has a primary and secondary ac...
- Sat Oct 22, 2016 9:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help required in logic
- Replies: 5
- Views: 5551
Help required in logic
hi, i have one query giving me "OPEN" AND CLOSED" acounts. the first part of query giving "open" Accounts union all Second part of query giving "closed"accounts The query contains the column Account_status determine "OPEN" and "CLH" account and ...
- Fri Apr 01, 2016 12:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: update then insert
- Replies: 1
- Views: 2165
update then insert
hi,
I have job from db2 to oracle and below is the process to inert the records
1.Push the records from db2 to oracle one time
2.push the delta(changes) daily
can I use insert then update in oracle connector or update then insert.Please advise.
I have job from db2 to oracle and below is the process to inert the records
1.Push the records from db2 to oracle one time
2.push the delta(changes) daily
can I use insert then update in oracle connector or update then insert.Please advise.
- Sun Jan 31, 2016 3:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: concatenate zeros to fields
- Replies: 2
- Views: 2128
concatenate zeros to fields
hi i have input fields like
49456.07
The output i need is
00049456
i tried by using
left('00000000': left(select_stats.TRN_VOLUME_COUNT2,6),8).
Giving me results
00000000
i need 00049456
The length of column is varchar(8))
Can you please help me on this
49456.07
The output i need is
00049456
i tried by using
left('00000000': left(select_stats.TRN_VOLUME_COUNT2,6),8).
Giving me results
00000000
i need 00049456
The length of column is varchar(8))
Can you please help me on this
- Thu Nov 12, 2015 12:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Default conversion error
- Replies: 0
- Views: 1924
Default conversion error
hi, i am getting the below error. Error when checking operator: When binding input interface field "FILLER_120" to field "FILLER_120": No default type conversion from type "raw[76]" to type "string[76]". FILLER_120 Is last column in file.i am reading the colum...
- Fri Oct 02, 2015 4:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: import error and no default value
- Replies: 1
- Views: 6015
import error and no default value
hi, i am getting the below error while reading the pipe delimiter sequential file. ##W IIS-DSEE-TFIG-00187 18:24:56(000) <sf_1,0> Field "MTDAdjustedAmount" has import error and no default value; data: {. 0 0 0 0 0 0d}, at offset: 93 ##W IIS-DSEE-TOIX-00154 18:24:56(001) <sf_1,0> Import war...
- Mon Jun 08, 2015 12:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: import fixed length file
- Replies: 2
- Views: 2309
import fixed length file
hi,
i want to import the metadata for fixed length file .IS there any way we can do it. i know there we can import the comma,tab separated files.
Can someone please help me on this.
i want to import the metadata for fixed length file .IS there any way we can do it. i know there we can import the comma,tab separated files.
Can someone please help me on this.
- Sun Mar 01, 2015 10:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: xml error
- Replies: 0
- Views: 1720
xml error
Hi i tried to create the xml file and using Xml stage as target and ODBC as source stage. Also i handle all the null fields but somehow getting the below error. XML_30,0: Fatal Error: CDIER0401E: An error occurred during XML parsing because=java.io.IOException: The character '?' is an invalid XML ch...
- Fri Feb 13, 2015 8:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: need to remove header and trailer from file
- Replies: 1
- Views: 1744
need to remove header and trailer from file
hi, i am reading comma separted sequential file layout as follows Header ---20150606NameOfile Columname-columnID records trailer i need to remove header ,column names and trailer so that i will load the records into the table. i tried with filer option command sed '1d;$d' which only stripping the he...
- Fri Dec 26, 2014 12:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: cobol copy book metadata
- Replies: 11
- Views: 7628
- Thu Dec 25, 2014 9:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: cobol copy book metadata
- Replies: 11
- Views: 7628
cobol copy book metadata
hi, i tried to import the metadata using the cobol file definition but getting the below error Error 1(line2)'PIC' PICTURE character string contains unsupported editing characters Error 6 (line12) 'PIC' PICTURE character string format is invalid. i am using sequential file to read the file and using...
- Sat Nov 29, 2014 7:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: xml stage output
- Replies: 2
- Views: 2622
xml stage output
hi, i am using XML stage and in XMl stage uses the below steps XML_parser:Name of the file document root:select the right xsd in the output step i am not able to see the columns just the first two columns rest of the columns not able to see in output link. i tried to figure it out where i am missing...
- Sun Oct 26, 2014 8:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: error reading EBCDIC file using CFF stage
- Replies: 1
- Views: 2713
error reading EBCDIC file using CFF stage
hi, i am reading EBCDIC file using the CFF stage and getting the error. cff_DEPOSIT_RESTRAINT_DAILY_ACCOUNT,0: Short read encountered on import; this most likely indicates one of the following possibilities: 1) the import schema you specified is incorrect 2) invalid data (the schema is correct, but ...
- Tue Aug 26, 2014 5:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: logic required
- Replies: 6
- Views: 4488
logic required
hi, I am using the db2 stage to extract the using the query to fetch the records from column using the logic expression YEAR(TO_DATE(AUC_SALE_DATE,'yyyy-mm-dd')) || '-' || WEEK(TO_DATE(AUC_SALE_DATE,'yyyy-mm-dd')) the results from this query coming as 2012-5 2012-44 2011-47 2012-18 2013-32 I want th...
- Mon Aug 18, 2014 6:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: fixed length error
- Replies: 13
- Views: 8878