DSXchange

I am trying to build a generic job to load a dataset to a target table in Teradata. We we are using the Teradata Connector. The job is generic, so I want the job to be abel to create/replace a target table if needed. The problem is that I cannot figure out how to specify a primary index. By default,...

Found a topic that might be what we are looking for...

viewtopic.php?t=128346

Brad.

sajidkp wrote:Hi,

You will get the Answer If you Search in this forum .... i faced the same problem and got sol from this forum...

Sajidkp, I don't suppose you could send a link to where you found your solution? Or what to search on?

Thanks!

Brad.

ray.wurlod wrote:You have a routine with an improper entry as a Parallel Routine. ...

I know this is an ancient posting, but we are running into this now. We are converting from DS8.0.1 to DS8.1 and are getting the same issue compiling buildops. What do you mean by 'improper entry'?

Thanks!

Brad.

We heard back from IBM and this functionality will be added for DS8.5, but so far there is no retrofit patch for 8.1. We are opening a PMR to request one. If anyone else out there is looking to do the same thing in DS8.1, I recommend opening a PMR as well. The more customer requests they receive, th...

We sent this to IBM and it sounds like it is a known issue. The response I got was that the TRANSLATE command is no longer used in this context in DS8.1 adn DS8.5. We are in the process of going to DS8.1, hopefully in the next 2-3 months. It did not sound like there was an existing patch for DS8.0.1...

dennisroser wrote:there is a patch that solves this issue.

The 'Connectors Rollup Patch 1', from august 23rd 2009 solves this

regards

Peter

Is this patch available for DS8.0.1 or for DS8.1? We are on DS8.0.1.

Thanks!

Brad.

How about using the dsjob command? From Unix:
We have a wrapper that we use to kick off all DS job and it ends by pulling the logs with the above command, reformatting a bit and outputing to a log file.

Brad.

Sorry, forgot the other part of my question. What is the difference between dsexport and dscmdexport?

Thanks!

Brad.

We are migrating from DS7.51a to DS8.0.1 and have need to make some XML exports of jobs from both sides. On the DS8 side, the dsexport seems to be doing what we need and exporting all related items for a job (buildops, table defs, etc.). However, the same command does not appear to give full output ...

The PMR was 88246,999,706 but was originally opened because of the abnormal amount of time taken to delete a project. The support sent us a procedure ( and the script ) to manually delete a project as well as a procedure to delete a job ( using same script ). Ghila, how long do you defined 'abnorma...

Thanks for the info. Our Infrastructure guy found a similarly named script in the XMeta directory structure called DStageWrapper.sh. We are on 8.0.1 vs. 8.1, perhaps the *81.sh refers to v8.1? He ran the script and it didn't find anything related to our project. Then he looked out in the Projects di...

Thanks ghila, I'll look into it. Did you have a PMR or case number that I can reference when we talk to them?

Brad.

ArndW wrote:The schema is still there, this could be the result of a partial delete, i.e. someone trying it from the (undocumented) commands in DS. ...

Undocumented? Are you talking about the dsadmin comand and the -deleteproject option? Should I not be using this?

Brad.

Assuming that you are dsadmin when (not) creating the project, verify that dsadmin has all privileges to the XMETA database and all tables therein (at least all those that relate to DataStage). ... I'll check it out. So the theory is that maybe dsadmin is missing some permissions and didn't clean o...