DSXchange

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.

I have 5 Job Activity in my sequencer.

How can I pass the a particular job name which has aborted to Notification Acitvity?

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

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

Hi Ray,

I mean all the jobs designed to be called in the sequence. I want the job names in a notepad.

Thanks

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?

Thanks. Its working fine.

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.

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

Hi,

I got the issue. Actually i was missing defining derivation and description in XML input stage in Output tab. After giving values, I am able to run the job..

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

Its a Passive stage as it does not modify the data. It can only change the metadata not the actual data.

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

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?

Hi All,

I found the solution myself. Delete the datasets that you are creation in the job and create them again or either change the datasets name. After this, the job will ran fine.

THanks