DSXchange

Thanks James. By "active" do you mean "installed"? I would think that you should be able to have two versions installed but only have services running for one version at a time.

Thanks,
Vince

You need two stage variables IsDup - set initial value to 0 and set the derivation as: IF DSLink2.deptno = LastValue THEN 1 ELSE 0 LastValue - set initial value to 0 (or any value that will not match anything coming in from the source) and set the derivation as: DSLink2.deptno Then in your output li...

I was able to find some documentation on changing the DataStage itag setting but it was specific to Unix. In it it said to verify the itag was changed in the uvconfig file. I went and looked at the uvconfig INSTANCETAG parameter and the comments say that it's valid on UNIX only. So, is there any way...

Initially we want to have the two co-exist during implementation especially in production so we can continue to run our nightly cycle using 7.5.2 while we bring up 8.1. Once the cut over is complete we would uninstall 7.5.2. Is there some documentation you can point me to that explains 'itag' and ho...

Has anyone tried installing 8.1 on the same Windows server that had a previous version installed? We currently have 7.5.2 installed on brand new Windows servers and are getting ready to upgrade to 8.1. Just wondering if there are any issues if installing 8.1 on the same server but on a separate volu...

Hi All, I'm trying to determine best practice for disaster recovery. There can be two possible issues. 1. The DW database crashes and needs to be restored to a previous backup. In this case hashed files for data, sequences, and max load dates would be out of sync with data. 2. ETL server crashes and...

Thanks guys...this is exactly what I was looking for.

Does anyone know where I can find some good documentation on Universe? I'm particularly interested in any information to help interpret the results of the "ANALYZE.FILE FileName STATS" command and improving hashed file performance.

Thanks!

Change SELECT to DELETE in this query and you have it!

For some reason I knew you were going to say that. That did it!

Thanks,
Vince

Ray, We don't really need these saved definitions. We had an Oracle consultant helping us get up and running with PeopleSoft EPM and he was showing us how to save table definitions. I did run the query as is with no records returned. I added another % at the end of the definition name and got the fo...

I'm doing a dscmdexport of a project and got the following error: DSExport started at: 3/3/2009 1:23:57 PM Could not get object '#$OWS_SCHEMA#PS_ETL_INPTLNK_LOG' from Repository/Table definitions (Record #$OWS_SCHEMA#PS_ETL_INPTLNK_LOG in file DS_METADATA does not exist) Total error(s): 1 DSExport e...

Craig,

I tried this this morning and it was still aborting. When I went and looked at the documentation the example had

code = DSSendMail()

instead of

Call DSSendMail()

When I made that change with the other changes you suggested it worked fine.

Thanks for you help!

Vince

Craig, I tried just using the variable and I can get the job to compile now but it aborts after it writes the job list to the log. Here's the code and the error message: **** Logging for the jobs that are in Completed Successfully **** If Len(TRIM(CompletedJob))>0 Then Call DSLogInfo("The follo...

I can see there is an issue with the double quotes. Do you have an idea of how I can code this to write the job list in the body of the email? In the call to DSLogInfo, the following code is what writes the job list to the DS log: :CHAR(10):CompletedJob,"JobControl" How can I get the same ...

Craig, Thanks for you help. I tried putting in a call to DSSendMail but I'm not sure how to get the job list into the body of the email. Here is the code I used followed by the error message when I tried to compile the code. **** Logging for the jobs that are in Completed Successfully **** If Len(TR...