Search found 106 matches
- Fri Dec 20, 2013 12:53 am
- Forum: General
- Topic: Email Notification without JOB STATUS REPORT
- Replies: 4
- Views: 2920
Email Notification without JOB STATUS REPORT
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...
- Fri Oct 25, 2013 12:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: The offsets for record ID columns do not match
- Replies: 2
- Views: 2370
The offsets for record ID columns do not match
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...
- Thu Oct 24, 2013 10:33 pm
- Forum: General
- Topic: Issue with attachment in email notification
- Replies: 2
- Views: 2865
Issue with attachment in email notification
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...
- Wed Sep 18, 2013 6:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data validation issue in DS 9.1 environment
- Replies: 2
- Views: 2098
Data validation issue in DS 9.1 environment
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...
- Tue Jul 03, 2012 4:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Enterprise Edition Satge- Max Log issue
- Replies: 5
- Views: 3877
Re: DB2 Enterprise Edition Satge- Max Log issue
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?
How can I call the same script in the datastage job level?
- Tue Jul 03, 2012 4:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Enterprise Edition Satge- Max Log issue
- Replies: 5
- Views: 3877
DB2 Enterprise Edition Satge- Max Log issue
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...
- Tue Jul 03, 2012 3:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Enterprise Edition Satge- Max Log issue
- Replies: 5
- Views: 3877
DB2 Enterprise Edition Satge- Max Log issue
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;...
- Mon Aug 08, 2011 6:09 am
- Forum: IBM QualityStage
- Topic: Any challenge integration with Oralce Exadata usingDatastage
- Replies: 2
- Views: 2822
Any challenge integration with Oralce Exadata usingDatastage
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
I would like to know whether you see any challenge integration with Oralce Exadata (latest version) using Datastage 8.1
Thanks and Regards
Shrinivas
- Fri Jul 08, 2011 12:56 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: What is the process of Datastage TX and Information analyzer
- Replies: 1
- Views: 16104
What is the process of Datastage TX and Information analyzer
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...
- Wed Mar 16, 2011 10:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal error code 139
- Replies: 1
- Views: 2319
Fatal error code 139
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...
- Fri Jan 28, 2011 2:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: IIS-CONN-ODBC-000004
- Replies: 2
- Views: 11178
IIS-CONN-ODBC-000004
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...
- Mon Dec 13, 2010 6:55 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to configure visual studio in Datastage 8.1
- Replies: 1
- Views: 2300
How to configure visual studio in Datastage 8.1
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
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
- Thu Dec 02, 2010 10:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: [IBM(DataDirect OEM)][ODBC SQL Server Driver]Invalid time fo
- Replies: 3
- Views: 3928
[IBM(DataDirect OEM)][ODBC SQL Server Driver]Invalid time fo
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...
- Thu Nov 25, 2010 9:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Concatenate multiple rows delimited by comma
- Replies: 4
- Views: 4540
- Thu Nov 25, 2010 8:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Concatenate multiple rows delimited by comma
- Replies: 4
- Views: 4540
Concatenate multiple rows delimited by comma
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
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