DSXchange

I'll have to check on the NLS question, it shouldn't have been enabled but was installed by someone else while I was on vacation. Is there a quick way I can tell?

Haven't gotten to support yet on this, thought I would post here first.

This is a new one on me and I'm not seeing the solution. Have a new server running HP-UX 11.11 with a fresh install of 7.5.2 on it for testing purposes. Trying to run a shell command from DSExecute gives the following failure: Warning! One or more of your selected locales are not available. Please i...

Ultramundane wrote:I have found that since IBM took over the licensing a few months back that they give you more then you need and trust you to pay for what you use.

I haven't seen anything like this.

Ultramundane also wrote:Or, it is possible that they just made a mistake.

That's where I'd put my money.

This - leveraging hashed files - is really basic stuff and core to properly using the product. It's not something a post or two on the web will help a great deal with. Do you have any DataStage resources locally there with you, people that are more familiar with the product that could help? Have you...

Anyways, after getting 7.5.2 I had to request that Ascential create patches for about 20 fixes that never went into 7.5.2. Crazy. Yikes... are these patches primarily for one product over the other, parallel versus server for example? I'm in the process of getting my hands on the 7.5.2 version of S...

No, that just adds a zero time to a given date but doesn't automagically make it a 'timestamp'. Plus you may (or in this case not) need the milliseconds you've added on. A timestamp is a date/time in a specific format, usually ISO like so: YYYY-MM-DD HH24:MI:SS So there's typically more than just st...

That just sounds like normal hashed file reference work. Can you not build a hashed file with the appropriate data and look it up in the XML job flow?

You need to rethink your approach. Why are you calling jobs from a Transform? Explaining your overall goal with these jobs would go a long way towards helping us help you figure out the right way to do this. Typically, the first job would be run by a Sequence job and the results of the query would b...

We have both Datastage server license for 5 user and 4 CPU...now we need to increase the user limit.. Now the vendor is asking almost equal amount of money which we used to buy the whole new software...it is really stupid.. Does it really cost that much to add users? Heck no. Someone must be confus...

Jagan222 wrote:How can we clean a repository.....

You might want to specifically state what you mean by 'clean' in this context... what brought you here to ask this question.

Post an example. I've never had any difference in the output, DS versus command line, of any bulk load related files.

Of course, we're in the Server forum and I'm talking about the Server version, no clue if the 'Enterprise' stage porks that up somehow in a Parallel job.

I'm assuming that's what the "not yet, wink wink" message meant - it is coming in Hawk from what I understand.

I just do it the old fashioned boring way - export and UltraEdit.

No, .bad files are simple text files.

i want to call a job2 passing a parameter... job2 is just a select on db, returning 2 values... You might want to explain how in the heck this 'job' is returning anything like two values from a database. All you get back from a DataStage job run is a status. Once you explain exactly what it is you ...

Just declare it as a char(8).