DSXchange

Hi All , This forum helped me a lot in resolving many of my technical issues in datastage . Now i want to ask a question not related to technical . I have been working in datastage from the past 1.5 years . I want to move to US .I want to know how datastage future going to be . Now its a part of web...

Hi Sunny , Thanks for your reply .Actually whats happening is ......... I am having a EBCDIC binary file and i am converting it into ASCII --1 st job In 2nd job i am reading the o/p of first job and parsing into different fields . The o/p of first job is char(250) ---- fixed width , no delimiter I a...

Are you using Sequential File stage or Complex Flat File stage? Your mention of packed and sign position properties suggests the latter. ... Thank you ray for your response . I am using sequential file stage only .I think we have those properties i mentioned in the sequential file also .I am facing...

Hi Everybody , Thank you all for solving many of my problems. Now i am facing another problem . My job design Seq ----------->>> Trans ----------->> oracle I have some decimal fields in the input sequential field .The format i specified for decimal fields is ---- packed=no(overpunch) signposition ( ...

Hi ,
which database stage are you using ?/

If you are using oracle enterprise stage then there are different options like

Load , Truncate , Create , Replace ......You can use anyone according to your

requirement .

Thank You reddy for your response .I saw the physical table definition .Its NUMBER(5,0) only .Still i am unable to resolve this problem .Have anybody experienced this type of problem ?? Please suggest .

Thank you all

Thank you ray for your response . My input sequential file is not having any records with field f1 greater than 5.I am having fixed width flat file .I specified in metadata of sequential Even I tried the following If IsNull(F1) then 99999 else F1 --------- Inserting 99999 in database for NUll value ...

In Sequential file ,I mentioned it as F1 --- DECIMAL(5,0).

In Oracle Enterprise Stage I specified it as DECIMAL(5,0).

While creating table I specified it as F1 number(5,0).


Thank you .

Hi thank you chulett for your prompt reply. Sorry for not mentioning the error correctly . Below is the error i am facing when i am mentioning If IsNull( F1 ) then SetNull() ELSE F1 in the transformer .... ORA-01438: value larger than specified precision allowed for this column. If Isnull(F1) then 1...

Hi Everybody , I am working on 8.0.1 version of datastage ( Information server ) . My job design is as follows . Seq file -------->> transformer ----------> oracle enterprise stage . My sequential file contains decimal fields .I am specifying the format as packed ,No overpunch because it came from m...

Your head -1 command needs to be followed by the file name. The Sequential File stage reads stdout of the command rather than reading the file and applying the filter command to it. ... Hi ray , Thank you for your reply .Still i am facing the same problem even though i specified as you suggested he...

Hi All , I am facing a problem in using filter option in sequential file .Suppose i am using head -1 in the filter property of output tab, I am not able to see any difference in the ouput ..... I tried with 'sed' command also ....still same result .... Can anybody help regarding how to use this prop...

Thank you brain . Its giving the same problem. I am still not able to resolve the problem.I am unable to insert NULL into a oracle stage. When i am browsing all posts related to it , I found the below statement Oracle Enterprise Stage issue (ecase 104805) -----------------------------107791 Oracle E...

Hi everyone , Thank you for responding to my query.My input schema is as follows record {final_delim=end, delim=',', quote=none} ( YEAR:nullable string; QTR:nullable string; FILG_DT:nullable string; A:nullable string; B:nullable string; C:nullable string; S:nullable string; L:nullable string; P:null...

Hi ray ,
Once thanks for your response.

In the metadata , I am specify just datatype.I am not specifying any length.Still i am able to view data.

Year char

Regarding the null field value , I am using for field YEAR.I am not using for all fields.