DSXchange

Hi Team, we have designed Email Notification seq for sending E-Mail with attachment.. If I check below option in the Mail_Notification ..It's working fine. Option--->Include job status in the Email. but my requirement is no neeed to send JOB STATUS REPORT in the subject. If I uncheck the above optio...

Hi All, We are reading data from UF records which are stored in multi record COBOL copy file. stgCFF_Source,0: Input buffer overrun at field "stgcff_source_record_type.TRL.CFF_FILLER_22", at offset: 18 stgCFF_Source,0: Import error at record 17194799. We would like to know how to get probl...

In the Attachment option, we are passing two parameters as #Src_Dir##File# #Src_Dir# for /data/Proj/source/Arrival/ #File# for File name We need to send one file attachment through Mail .we are not able to send that attachment. There are issues mentioned below. In Datastage Warning: sSeq_BOS_STAG_PP...

In this specific issue In the Source Table, the Column name -> Source has been defined as Char in both DataStage 7.5 & 9.1 environment. On detailed analysis of the view data, the following data get populated in the 7.5 environment Target Column _> DCMNT_TYPE_CD is getting populated with the foll...

For this issue.. We have one script .. that script( for unique month,year) is working fine from command line.. we are getting unique data based on the month,year columns from source file.
How can I call the same script in the datastage job level?

Thanks for your response... we tried with 1.array size : 1000 and commit size: 2000 2.array size : 10000 and commit size: 20000 3.array size : 5000 and commit size: 10000 4.array size : 10000 and commit size: 10000 5.array size : 100 and commit size: 200 DB2_UDB_Enterprise stage(DB2 Version:9.5) Dat...

Hi, The job cleans the old data in staging table for unique month,year(i.e.,delete the records from target Db2 table- records count: 7.5 lakhs) write Method:Delete rows Delete Rows Mode:Auto-generated Delete. fatal errors: 1.tblCCMIPreStagdel,0: ERROR during execution of DB2-CLI requests: SQL_ERROR;...

Hi Team,

I would like to know whether you see any challenge integration with Oralce Exadata (latest version) using Datastage 8.1

Thanks and Regards
Shrinivas

Hi All, I have a requirement to read shift files and chip file and desided to use datastage TX but I am not clear about the process flow. I am very new to Datastage TX. I want to know the process flow between Datastage TX, Information analyzer, Fasttarck and Designer. Where exactly Datastage Tx lies...

Hi Team, Job design is just reading data from source and loading into target, there are no transformation logics are in it. If you run this job individual it is running fine, If call same job in Jobsequence it is aborting with Fatal error code (139). Any idea why we are encountring this.. What is th...

Hi , I am getting below error if I use ODBC Connector stage. [IIS-CONN-ODBC-000004] ODBC function "SQLBindParameter" reported: SQLSTATE = HY104: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Driver]Invalid precision value (CC_OdbcDBStatement::dbsBindInputs, file CC_Odb...

Hi All,

I have requirement to integrate(Configure) VSS(Visual studio 2008) into datastage, so that is it possible to do direct check-in checkout(Import and export datastge .XML or .dsx file using Datastage 8.1

If possible please let me know the procedure to configure.

Thanks and Regards
SHRINIVAS

Hi, I am getting [IBM(DataDirect OEM)][ODBC SQL Server Driver]Invalid time format. data is not loading into SQLServer 2008 In the source I am getting date has 2008-05-10(YYYY-MM-DD) format some of records getting null values In my Target SQLServer column data type is date with null. I have changed v...

We are using Datastage datastage 8.1 only horizal pivot is possible.

Please let me know is there any other way

Thanks in Advance
SHRINIVAS

Hi Team,

How to Concatenate multiple rows delimited by comma

Ex: I have a column

1025758
1025758-1025759
1025758-1025759-1025758-1025759

Output would be


1025758,1025758-1025759,1025758-1025759-1025758-1025759

Thanks and Regards
SHRINIVAS