DSXchange

Hello, We are upgrading from version 8.0.1 to version 8.5 of IIS. I am testing the jobs to ensure everything works fine. However, I ran into an issue in a job which has a CFF stage as its input. It has multiple readers (4) per node set-up to enable faster reads. These jobs are working well in the ol...

Hello Gurus, We have installed v8.5 FP1 very recently and are experiencing this warning(s) when we are running jobs: Unable to Write Temp_<Project_Name>_<Job_Name>01 to OMD.XML.DIR ... Unable to Read Temp_<Project_Name>_<Job_Name>_ReleaseTest01 from OMD.XML.DIR I have searched the forum and came acr...

Thanks Ray.

I used your suggestion and tweaked my job design as such:

1) Piped the output of the paste command to the "tr" command to convert the new line into "|"
2) Used Ereplace to replace "|" with "".

This did the trick! :D

My experience is that, when the final item in the list fails, it is usually for this reason. You can add an extra command to your UNIX command pipeline to remove empty final line, or you can interpolate a user variables activity to achieve the same end. Thanks for the reply. I agree with you. I add...

I haven't checked it in a hex editor. I probably should have. My suspicion arises from the fact that the process is simple enough that this is the only explanation I could think of. I will check it and let you know. If my earlier statement is wrong, please do let me know if there is something else. ...

Scenario: I am trying to get row counts for all the tables that exist in a Schema and put them into a "csv" file which I am e-mailing to the team (an auditing process) My approach: I have 2 jobs (PX) in place for this. Job-1 queries the systables and gets the list (<schema>.<table> format...

Thank you... :D

Exact means exactly that. In SQL terms, the exact value of a column is its entire contents. Pardon me for stating the question in an ambiguous way, Ray. What I meant to ask is that, in the where clause, after the '=' should I be giving: CATEGORY = '\Jobs\parent category\Child Category' (the full pa...

Thanks Ray.

A General question though is, if I have to do an exact category search, should I give something like, CATEGORY = "\Jobs\coverage_performance"? Or just CATEGORY = "coverage_performance"?

Thanks for all your replies. The command I was providing worked now - after connecting to the project. However, I had to log-off and log back in before it worked. I didn't understand why and how it worked now as opposed to before. So, I will put a note for next time to directly connect to the projec...

LOGTO You are correct Craig. I haven't done LOGTO prior to executing this query...However, even now, I am not getting the result >LOGTO BI_W1_DS_DW1 >SELECT NAME FROM DS_JOBS WHERE CATEGORY = 'coverage_performance'; 0 records listed. >SELECT NAME FROM DS_JOBS WHERE CATEGORY = "coverage_perform...

All, I need to get a list of all the jobs under a category. I have done this before using "SELECT" on "DS_JOBS" table. However, this time, I am not getting any results... I did: user@SERVER:/opt/IBM/InformationServer/Server/DSEngine>./bin/uvsh DataStage Command Language 8.0 Licen...

I do not have PMR #, but I have the following info for the patch PATCH FOR APAR : JR34751 PATCH NAME : patch_JR34751_client_windows_8010-8101 COMPONENT : Common Connector Framework LAYER : Client OPERATING SYSTEM : Windows SUITE VERSION* : "8.0.1.0 - 8.1.0.1" COMPONENT VERSION* : "1.0...

Sorry for these frequent updates. I was right initially in saying the IS Manager is not available for 8.0 . It was introduced beginning 8.1. http://it.toolbox.com/blogs/infosphere/new-source-control-support-in-information-server-81-and-datastage-81-27522 I am back to square one again :) . How do I a...

No problem. That is what I thought. I contacted the person who opened up the PMR for me (unfortunately, I cannot do that at this point of time) and he is unavailable...he is not responding and not at his desk either. So, until then please search for that dll that I mentioned in my previous post and ...