DSXchange

I'm getting the following warning message when writing to a text file: LoadPartEffectivity..part_app_debug.part_app: nls_map_buffer_out() - NLS mapping error, row 106 (approx), row = "81349 M39029/1-101 F/A-18E/F A05FAAAXAAAE99 01 P " I am not explicitly using any maps other than the defau...

I haven't seen this technique before, Ray. This accomplished the same thing I was trying to do, but with a sequential file. Cool.

Another one to add to the old bag of tricks [:D].

Thanks,
Tony

If you replace all the pipe chars with @VM, you can write them to a hash file and read them back out "normalized". On the output link you have to define the column that has this data in it as multi-value (type = 'MV') and change the "Normalize on" field at the top of the tab to t...

Andy, What I would do would be to write a routine where you pass it Title and NumUses as an argument. This routine would return a string containing a multi-value field with Title the appropriate number of times separated by a @VM (look up the FieldStore function to create this string). Write this mu...

I just know that this is gonna be wrong because I haven't tried it myself, but other folks have talked about using the Reporting Assistant to report on a project, then get the data out of the Access database that it uses. Sorry, I don't know what the DB name is, but it shouldn't be too hard to find....

Could be that your environment isn't the same on your production box as on the development box. I would look at where your datastage directories are in the path and shared library environment variables. I suspect you'll find something wrong there.

Is this a Unix box?

tony

Sure looks like the Oracle drivers are not correctly configured on the system. Hard to imagine that the ODBC drivers work correctly when the Oracle driver doesn't. The only thing I can think of is that the server name and the ODBC DSN are not the same and perhaps, you're using the same name in both....

Badhri, I am by no means an expert at this, so be patient. You didn't answer my question about setting up your environment. Did you look into this? I know there are some environment variables that need to be set up correctly and, as I mentioned, there is a script file in the ../DSEngine directory ca...

Badhri, Please supply more information as to the nature of your problem. A couple of basic questions to get things started are: - Can you run any jobs successfully from Director? - Are these the jobs that give the coredump? - Is your command line environment set up correctly? I think there's a "...

Heh. Wouldn't you know it would be something like that.

Ah, well, hope your vacation was good!

Thanks for posting the answer.

Tony

Vikas,
Make sure that you get XML v2.x from the Ascential site. It's a lot more capable than v1 that comes on the DataStage CD.

Good Luck,
Tony

Viswanath.s and Craig, I've found the "Multi-row reference link" functionality of the ODBC (and Universe) stages to be very helpful a couple of times. This is a reason to use the ODBC stage instead of the Oracle OCI, as the Oracle OCI stage doesn't support that functionality. Hope this hel...

Are you doing the FTP in a DataStage job (in an FTP stage)? Or in an external process? It might be better to FTP the job over outside DataStage, then try reading the file and converting it. There are some options in the metadata that allow DataStage to ignore incomplete fields and rows... That also ...

You may find a recent thread helpful.



Good luck!

Tony

Ravi, It is relatively easy to read job parameters from a file and run a job, setting the appropriate job parameters with values from a file. This can be accomplished with a Job Sequence job or Batch Job (I can't remember if v5.2 has job sequence jobs or not). For Job Sequence jobs, I wrote a small ...