DSXchange

Kenny, We have been having the same intermittant issue youve listed for Job 2, and weve never gotten any kind of resolution as to what is going wrong. Once in a blue moon, a job that had been running fine for days / weeks / whatevers will suddenly "start but not run". Like you, all we get in the log...

Arvind Where is this article? I would like to read it. I have used all the information that comes from monitoring a job and loaded into Oracle and other databases. If you have job start and end times it is easy to see the order the jobs run in. The designer is definitely not as clear when you have a...

Use the NUM() function to determine if something is numeric. You could also use the MATCHES operator to check whether a string contains purely numeric digits. Use substring operator or LEFT() or RIGHT() functions to obtain the substring to test. Thus, for example: Num(Column[1,4]) Column[1,4] Matche...

Yes, you use the Char() function to evaluate it. Best practice is to evaluate this function only once; that is, perform a constant declaration or assign to a variable early in the program, then use that token. For example: Equate TAB To Char(9) ... Line = Key : TAB : CustCode : TAB : OrderDate ... -...

This is a topic for an orphaned message.

Sure, either directly use CHAR(9) or set a variable to it, like TAB=CHAR(9), then use TAB anywhere you need to. Ex: TAB=CHAR(9) blah blah blah msg="This is before the tab":TAB:"This is after the tab" blah blah blah Good luck! -Ken --- lfrumke@sears.com wrote: > Hi everyone, > > I know how to use tab...

There is an article by Ken Bland and Michael Favero, titled "ETL Framework Methodology", that talks about an ETL Process Audit model to capture information on jobs, links, data stores (tables), etc. Has anyone implemented such a Process Audit Model to capture such detailed information during every b...

Hi everyone,

I know how to use tab delimiter in GUI (ascii 009). Can I do the same in
Basic?

Thanks,
Leonid

Guys, can we *not* post messages to the list with return receipts requested? Apparently, our corporate email system is the only one stupid enough to actually send one back to the list, but still... Thanks. -craig Craig_Hulett@rsausa.com wrote on 05/07/2003 10:37:49 AM: > > Return Receipt > > Your Jo...

Return Receipt Your Jobs starting but not running or aborting document : was Carlos Pimentel/Madison/GNIC received by: at: 05/07/2003 11:45:08 AM CDT

Return Receipt Your Jobs starting but not running or aborting document : was Craig Hulett/Englewood/GNIC received by: at: 05/07/2003 10:36:15 AM MDT

=========== Monday 5/5: =========== I moved a new version of a job (Job 1) into Production and compiled it. ============ Tuesday 5/6: ============ The new job didnt run and the log entry was: "DS.SCHED: Cannot find record JOBPARAMINSTS in executable job file RT_CONFIG723" I looked through old messag...

Paul, Thank you for the response. I think that we will try the Citrix server setup because we dont have a lot of other options. It is good to hear that you are using it and it all works very well. Ill keep the group aware of the outcome. We will initially have 3-5 concurrent users around the world a...

Tim Im not sure about 6.x but we use 5.2 on a Citrix server to allow other offices accross the world to access datastage and it all works very well. On occasions I dial in from home and access the Citrix server through my Apple Mac to do datastage development. Even at 56k (no broadband in my village...

Hi Guys When I created my odbc connections to both the Universe and SQL 2000 databases the entries were not automatically added to the uvodbc config file. I have added them manually, but would like to know why this has happened and if it is a common problem. Thanks. Mark Ewart-Phipps Centerfield Sof...