DSXchange

Hi Ernie, Thanks for the elaborate explanation. However, I still request for one small clarification from you. Suppose in the first production server, I generate OMD. (They will be stored in IBM\InformationServer\ASBNode\conf\etc\XmlFiles) Now, logging into second production server, is there a way I...

Thanks Ernie and Ray!
Is istool utility available in 8.0.1 version?

Hi all, Can anyone help me how to export operational metadata from 1 environment and import into another. The use case is this: In production we are implementing a 2nd LPAR on 1 of our 2 production machines. On this LPAR we will install a separate instance of x-meta. This 2nd LPAR will have the Meta...

Hi everyone, Since two days, my scheduled job is throwing this kind of strange error message: JobControl (): Controller problem: Error calling DSSetParam(JobRunDate), code=-4[ParamValue/Limitvalue is not appropriate] The reason I said strange because, it never threw this error and I have not changed...

Hi,

Is there a possibility that I can automate a DS job which runs a unix command to back up the DS server. I would like to know if theres a command to back up the DS server. Can anyone help me?

Thanks in advance

Hi,

Today morning, I found one of the scheduled jobs get aborted due to the following error:

Unexpected termination by Unix signal 9(SIGKILL)

Can anyone help me fix this?

Thanks,

Thanks a lot Chulett, I will refer that document.

Hi,
Can anyone please explain how I can tranform an .xml source file data into odbc database. This is the first time I am using xml source files. I am not sure which transformer to use. Can anyone suggest me how to pick up the xml source file. using folder or sequential file or XML input?

Thanks

Craig,

There is no specific rule that I must XML transformer stage. What is the disadvantage if I use that stage.

I tried dragging a link from XML Transformer stage to the database stage, but XML transformer stage has output settings tab where I can choose only from URL/file path or Text.

Thanks

Craig,

I mean in the XML transformer stage, I do not see any option to output it to a database. I see only output to a file here. We are using Netezza database. Hope this cleared your question.

Thanks for the reply

Hi All, I have a requirement where I need to implement a bi-directional data integration using parallel job. I get time clock data from the source in XML format. This should be transformed and loaded in our database. Again, any changes in this time clock data should captured from our database and ou...

Hi, I am trying to import data from source and write to a sequential file using parallel job. The source columns have nullable fields. I am getting the following warnings: 1) When checking operator: When validating export schema: At field "SLM_SLS_DLRS": Exporting nullable field without nu...

Can we run Perl Scripts from DataStage Parallel Job(Before/After Sub-routine)?

Thanks in Advance,

Aparna, Thanks for your reply but let me be very clear this time. See, My Datastage job has a target which creates an external table. For your ref: create external table DB..Emp SAMEAS DB..Emp_v USING (DATAOBJECT ('/nz/hrms/data/target/Emp.txt') COMPRESS FALSE FORMAT 'text' DELIMITER '|' ); Now this...

And to be more precise, I am not using the command directly in unix client.
I using that command in a shell script which is placed in after-job sub routine of my ETL job