DSXchange

Talk to your Sys Admin - this could very well be on purpose. We have a userid that can only be used to authenticate a DataStage session but cannot be used to log directly onto the box. It's meant to be a 'read only' type account for DataStage use only. Not sure exactly how they managed it, but I ass...

You are just trying to import the metadata of the file? It makes a 'best guess' as to the data type of each field based on what it finds in them, but I never stick with what it comes up with. Define the data types yourself, overwriting whatever it comes up with. Heck - make them all CHAR or VARCHAR ...

Not that this is all that helpful, but you can look them up from the command line using the 'oerr' command: $ oerr ORA 1480 01480, 00000, "trailing null missing from STR bind value" // *Cause: A bind variable of type 5 (null-terminated string) does // not contain the terminating nu...

Talk to your DBA, they love to explain stuff like that.

Welcome! :D Not quite sure who 'u plza' is, but maybe I can hep instead. Take a portion of your message - for example " the value of the PWD environment variable " without the quotes, of course - and do an Exact search of the site. You'll find this has been asked and answered several times before.

Not a whole lotta 'how' there. Rafik, all things are possible. Do you need to do any preprocessing to determine region? I get the impression you've already got all the information you need for that. Actually, do you need to do any processing on this 'data set' or do you simple need to split it per r...

Sounds like it's time to mark it as Resolved then!

ray.wurlod wrote:You guys dealing? Why do you need records about hash?

Drug humor.

Which boils down to the fact that CREATE.FILE is used when you create a hashed file in an account while mkdbfile is used when you choose the pathed option to simply create the hashed file in a directory. No, the 'file dictionary' isn't like an index, it stores the metadata for the hashed file. It is...

Does that also mean the emails *in* to DSXchange are not being received? That might explain why the typically ever-so-happy-to-help Walter hasn't responded to any of my emails on the topic.

As noted here others are seeing the same behaviour. Honestly, I'm surprised it hasn't been resolved yet.

Create an After Job subroutine that checks the job's INTERIM status and if it says it will be aborting when it finishes, delete this 'temporary status file'.

When I changed to manual mode its working fine , but not sure where data got loaded , do i have to write any script to load this data file created by datastage or data stage does that(loading) internally , I checked, data and control files got created to the specified location , but my target table...

Welcome. :D An Oracle 'like' won't help search for all of the 'variances' you've listed. A series of them might. What you are looking for is MATCHES, I would think. "The help in DataStage is hard to use unless you know what you are looking for" Sure, it always helps to know what you are looking for ...

So how exactly did you resolve it? I vaguely recall a way to tell it where to find the .netrc it needs, but wondering specifically what you did for this. Thanks.