DSXchange

The .log files are hidden in the Scratch directory that is defined in your config file (something like ../Ascential/DataStage/Scratch) LOG=ora.8105.41297d.0.log That ".log" file is where these particular sqlldr errors would be. You'd need to find it, I assume it would be in the job's Proje...

Is there a way to automatically generate a schema file? I have a job that exports a dataset to a sequential file using RCP. If I could generate the schema file for this dataset, it would be possible to import the sequential file back in to a dataset by using the schema file to specify the column nam...

Did you specify Drop for "Condition not met" or for "Lookup failure"? You need to set it for "Lookup failure". Then you shouldn't get the warning that the keylookup failed Hi All, I am doing a lookup on a sequential file and the lookup file is also a sequential file,I a...

You have to try if you can send an email on the datastage server, not on your client. Also check if the email is send through the same mailserver. In the Datastage directory for your project, there should be a file dssendmail_template.txt or dssendmail.txt. There you can see which command Datastage ...

It's probably a limitation on your mailserver, not on Datastage.
Try if you can send an email outside your company from a mail client outside of datastage, but on the same server and see what happens?
Probably you'll get the same error message.

I think you can import them in Datastage without a problem as long as your Oracle client can read them. The error "TNS: Could not resolve service name" has nothing to do with the database being Oracle 10 though. It means that it cannot connect to the database because it cannot find the dat...

DSguru2B wrote:In the filter command put in the following awk command.

Code: Select all

awk -F"\~~" '{print NF}'

This should take care of it.

Thanks a lot. That does take care of it indeed.

chulett wrote:Count single occurances, divide by 2 and then add 1.

Smart.

Is there also a way to count the 'real' ~~ delimiters in case a ~ could occur in a string?
So that when the string is 'field~1~~field~2~~field~3' the result is still 3?

I want to count the number of fields in a ~~ delimited string. For example if the string is "field 1~~field2~~field3' the result should be 3. I thought I could do this using the Count function (and add 1) or the DCount function. Though when the string is 'field1~~~~field3', I'd like the result ...

We found out what changed.. someone added several new NLS maps causing the server to need too much memory. After removing the new NLS maps and restarting the server everything worked just fine again.

This problem occurs in every project though, including projects that have been running without any problem. What has changed? "Nothing" is not the correct answer. ... I wish I knew.. In the Datastage projects nothing. We haven't been able to find anyone in Operations who are running the s...

Since two days we are getting "Abnormal termination of stage <stagename> detected" for all our jobs that read or write to Oracle oci stages. When we reset the job, we get additional info like From previous run DataStage Job 15 Phantom 29653 jobnotify: Error 911 occurred. DataStage Phantom ...

If one of the two columns is NULL, the result will be NULL and not what you're expecting.
You'll have to catch the NULL and convert it to an empty string

Hi, I have a file that contains delimiters of 2 characters (e.g. ||). How can I read this file because DS Designer accept only a delimiter of 1 character? Kind Regards, Erik If they're both the same separator like in ||, you could use | as a separator and use every other field for the further proce...

I would say day of the week equals Saturday and daynumber is 7 or less and that's all it takes to see if the passed date is the First Saturday of the month. But is that what you mean indeed? It sounds too simple