DSXchange

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...

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 ...

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.

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

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...

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...

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.

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...

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...

hi arnd thanks for reply and i tried myself by replacing the pictures with "S" and "V" rather than "-" and "."and it import without any error. please find below the copy book after correction: 01 TXT004SWORKSRECORD. 03 TXT004SCITSITEMSNO PIC S9(10). 03 TXT004S...

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...

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...

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 ...

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...

What would be the correct sizes for First field and second.
I am giving as decimal(9,7) for first X56216-INTEREST-DAILY-FACTOR PIC -9(02).9(07).

For second
X56216-INTEREST-DAILY-CHARGE PIC -9(05).9(06). giving as decimal(11,6).
please help me on this.