DSXchange

DOH! I knew that. Sheesh.... I just hate it when I ask a question after missing something pretty obvious! I always set that option ("Enable job administration in Director") in my projects so I can manage them. Somehow, I missed it when creating this project and forgot about the relationshi...

In the past, I've used the "Cleanup Resources" and "Clear Status File" (from the Job menu in Director) to fix a job that reports as running even though there is no underlying process; i.e., where the job has become disonnected from its process. However, I have a sequence that is ...

Though I've been using DS for about five years, I've had no previous need to change the default performance settings for any of our ETL. Recently, though, I've begun exploring what is available and have read lots of threads about these three topics on DSXchange. :) But a question remains unanswered:...

What file are you using for your BASIC? A sub-directory type 19 file or a hashed file? Can you try "CREATE.FILE MYBP 19", "ED MYBP TEST" and put in "PRINT 'Hello World'", file & "BASIC MYBP TEST"? :oops: Thanks for the direction. I checked and had created...

Being an old DATA-BASIC programmer, I often end up telnetting to the engine and doing preliminary development of functions and routines directly at Universe before I move into final testing in DataStage. However, I just recently built a new DataStage server an am having an issue I do not have on our...

Have a project where they need to take and generate the schema from the XML: XML to DDL or something like that. Beyond the initial XML-to-DDL, this XML will likely change and grow over time so they are looking for something that can do a diff of the schema and (hopefully) manage the DDL to update th...

I've a general question that I thought many here might have already answered in their own environments. Given that there are a number of feeds generating shared dimensions and fact tables in the warehouse (and that there will eventually be an ODS) and other groups desire access to the data in order ...

I just took at closer look at the message and there is a leading space between the (') and the "D:\Ascential..." I guess it needs to not have spaces between the tokens and the values. Removed them and it worked.

Thanks for your reply, Ray.

I am using DSSendMail as an after-job subroutine. Mostly, it works correctly but when I attempt to have it send an attachment, it reports: Cannot open attachment file 'D:\Ascential\DataStage\Staging\Orbit_rod\seqCompliance\Rejects\UnknownBase.csv' Which is the correct path and filename. I can confir...

Been a while since the last update. Wondered if you had gotten any further with this. I have the same issue. Been using OLEDB all along but now have an issue with trying to trap the errors instead of just having them sent into the log -- and those are not very descriptive. Trying to do that as we sp...

Well, of course after creating a very large post explaining everything, I actually found a couple rows with data that were causing the error. They weren't null or empty but had content that couldn't convert to numeric. Yeah, I know... :? Sheesh... Thanks to both for the info. P.S. I did learn that t...

[I've seen several of these type of posts but none helped to explain how to associate the error statements with the actual values. :( ] Are the line numbers (below) references into the DS generated code (i.e., the stage module in RT_BP1131)? If so, the line numbers don't match up with anything that ...

Thanks to all. Exactly what I needed. Figured someone had already done this before.

Is there a way to change the autopurge settings for all existing jobs in a project? I know you configure the initial autopurge settings in Administrator for a project and those settings are used when a job is created (right?). However, after a job has been built and you want to change the autopurge ...

chulett wrote:I assume you either ran out of disk space or this hashed file went up against the 2GB Barrier and lost, yes?

Exactly. Weird thing is, I'm pretty sure I had it set to my standard 3-day max -- and this is a very small job.

Anyway, that command resolved the issue. Thanks!