Hi,
I am getting a below error while running the job.
Data set, file set, or file "ora_Stg_Table:rd_Ora_Stg_User.v": Non-pipe (or non-virtual data set) with .v in its name
Any idea on the above error.
Search found 82 matches
- Fri Nov 16, 2012 12:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Non-pipe (or non-virtual data set) with .v in its name
- Replies: 2
- Views: 1679
- Thu Nov 08, 2012 4:00 am
- Forum: General
- Topic: Email Notification Activity
- Replies: 5
- Views: 3401
- Thu Nov 08, 2012 3:46 am
- Forum: General
- Topic: Email Notification Activity
- Replies: 5
- Views: 3401
Email Notification Activity
Hi,
I wanr to send email if any job fails in my sequencer with the job name and log in my email.
Please let me know how can i implement this.
Thanks
Atul
I wanr to send email if any job fails in my sequencer with the job name and log in my email.
Please let me know how can i implement this.
Thanks
Atul
- Tue Nov 06, 2012 3:39 am
- Forum: General
- Topic: Want to send EMAIL Notification
- Replies: 2
- Views: 2081
Want to send EMAIL Notification
Hi,
I want to send email on completion/Abort of each job. Please tell me how to configure the NOTIFICATION ACTIVITY and what settings I need to do at Admin Level?
Thanks
Atul
I want to send email on completion/Abort of each job. Please tell me how to configure the NOTIFICATION ACTIVITY and what settings I need to do at Admin Level?
Thanks
Atul
- Thu Oct 04, 2012 3:45 am
- Forum: General
- Topic: Get job names being called in Sequencer
- Replies: 3
- Views: 1232
- Thu Oct 04, 2012 3:24 am
- Forum: General
- Topic: Get job names being called in Sequencer
- Replies: 3
- Views: 1232
Get job names being called in Sequencer
Hi,
I want to know all the jobs being called in a sequencer and save the result in a notepad or excel sheet.
I can view all the jobs dependent on a sequencer through "Job dependency" but How to save it in a notepad?
I want to know all the jobs being called in a sequencer and save the result in a notepad or excel sheet.
I can view all the jobs dependent on a sequencer through "Job dependency" but How to save it in a notepad?
- Wed Jul 18, 2012 7:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String to Timestamp Conversion Error
- Replies: 2
- Views: 1247
- Wed Jul 18, 2012 7:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: String to Timestamp Conversion Error
- Replies: 2
- Views: 1247
String to Timestamp Conversion Error
Hi, Please tell me how to convert below string to TimeStamp format. 2012/06/04 03:10:23 AM I am reading the above value from sequential file as Varchar, and wanted to write into Oracle table as Timestamp. Please tell me what format should I specify in StringToTimeStamp() Function. Thanks In Advance.
- Wed Jan 11, 2012 12:08 am
- Forum: General
- Topic: What is @FM
- Replies: 2
- Views: 7311
What is @FM
Hi All,
I came across below function in my existing code. I want to analyze what exactly this does and what @FM refers to? Any idea?
Ereplace(Trim(Convert(@FM ,"", cmd_List_Files.$CommandOutput)), p_HrSrcFileDir , "")
Regards,
Atul
I came across below function in my existing code. I want to analyze what exactly this does and what @FM refers to? Any idea?
Ereplace(Trim(Convert(@FM ,"", cmd_List_Files.$CommandOutput)), p_HrSrcFileDir , "")
Regards,
Atul
- Fri Jan 06, 2012 1:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error occurred in call to ORPHCallActivePluginInitialize().
- Replies: 2
- Views: 3281
- Fri Jan 06, 2012 7:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-01857: not a valid timezone
- Replies: 3
- Views: 3471
ORA-01857: not a valid timezone
Hi, I have the below source query which is running fine in Oracle but while running in Datastage its giving an error "ORA-01857: not a valid timezone" Also I am able to view the data in Datastage. SELECT CNTRCT_ITEM_KEY, cast(to_char ((new_time(SOURCE_CREATE_DATE,'GMT',to_char(from_tz(CAST...
- Fri Jan 06, 2012 1:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Copy stage active or passive?
- Replies: 21
- Views: 8894
- Fri Jan 06, 2012 1:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error occurred in call to ORPHCallActivePluginInitialize().
- Replies: 2
- Views: 3281
Error occurred in call to ORPHCallActivePluginInitialize().
Hi, My requirement is to read a XML file and load that into table. Below is the structure of the Job: XML File Structure: <?xml version="1.0" ?> - <aaaaaaaaa> - <reference> <captureInformation captureTimer="1" capturedate="20111120072225" capturemethod="HOLA" ...
- Thu May 12, 2011 2:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DeadLock
- Replies: 1
- Views: 1441
DeadLock
I am just inserting the records in to the table and I am getting the below error:
"Unable to insert a record into the table due to ORA-00060: deadlock detected while waiting for resource"
Any Idea on the above error?
"Unable to insert a record into the table due to ORA-00060: deadlock detected while waiting for resource"
Any Idea on the above error?
- Thu Mar 17, 2011 11:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while running job
- Replies: 2
- Views: 1947