DSXchange

I validated and ran DataStage 7.5.2 jobs from Director with no results after compiling successfully. I validated and ran IIS 8.0.1 jobs from Designer with no results after compiling successfully. I then validated and ran IIS 8.0.1 jobs from Director with no results. In both cases no entries were log...

Jobs will compile in DataStage 7.5.2 but will not show any action on validate or run.The Director log shows no entries

Sorry for the confusion; we have DataStage 7.5.2 and IIS DataStage 8.0.1 installed on the same server each having their own dsenv file. We have developed the following scripts (start/stop) in conjunction with our mid-range staff for dataStage 7.5.2, IIS DataStage 8.0.1, ASBagent, Websphere Applicati...

Environment: We have DataStage 7.5.2 and IS DataStage 8.0.1 installed on the same server with IS Multi_Client Manager. Issue: When we execute our shut down script it will shut down IS DataStage 8.0.1. The question is how do we shutdown DataStage 7.5.2. The shut down script references the IS 8.0.1 ds...

IBM Case 515298 DataStage 7.5.2 accessing Teradata V2R6.1 using TTU8.1.) DataStage is a 32-bit application and it must 'only" point to 32-bit database libraries and not 64-bit (you have no choice unless you desire to move to HP Itanium and that unrealistic). This is true for Teradata, Oracle, D...

We are getting ready to install Information Server 8.0.1 Unix, Parallel from 7.5.1 Unix Parallel. We understand that the client has a 2 gig memory requirement. Our managers want to see this in writing but we can't find it in the IBM docs. Question: Is 2 gig a valid client memory requirement and does...

Both of these suggested options worked! NOTE: I replaced tablename with filename and all the jobs using that specific file were listed. I have turned the GTAR (AS FOUND) problem into IBM but they have not provided a case number. (This is an internal problem with DataStage/SQL (GTAR = general technic...

IBM has a Teradata Encryption patch reference CASE 500423 DS TD SYNC PWD Encryption.

Here is the Metadata that were trying to import. Question: The METADATA section is required to establish our 'load' Metadata but what is the following valued section used for and how does it tie into the xml input stage? <?xml version="1.0" encoding="UTF-8" ?> <FMPXMLRESULT xmlns...

The \:vTableName:\ modification results in a syntax error: *------Searching for all jobs with vTableName - Original SQL in Routine ------* cmd = \SELECT EVAL DS_JOBOBJECTS."IF INDEX(@RECORD,\:vTableName:\,1) > 0 THEN 'FOUND' ELSE 'NTFND'",\ cmd := \ DS_JOBS.NAME AS JOB_NAME FMT '40L' \ cmd...

Test Results (alias): I tried many combinations renaming, omitting 'as' etc with the same result (GTAR). ACTION: I am opening a case with IBM on this issue. New problem, same SQL: The SQL is not converting the vTableName variable consequently all result sets are NTFND. I have tried many different sy...

Your previous post with the \ and := worked without any problems executing from a sequence routine stage. (THANKS Ray) I then added in the AS FOUND logic and this errored out: cmd = \SELECT DS_JOBS.NAME AS JOB_NAME, \ cmd := \ EVAL DS_JOBOBJECTS."IF INDEX(@RECORD,'POPAPPL.ANALYSIS_VERSION',1) >...

HERE ARE THE TEST RESULTS USING DQUOTE (failed): ORIGINAL SQL - One Line (Works in DS Admin): cmd = "SELECT DS_JOBS.NAME AS JOB_NAME FMT '35L',DS_JOBS.CATEGORY,DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."if index(@RECORD,'POPAPPL.ANALYSIS_VERSION',1) > 0 t...

(single line) cmd = "SELECT DS_JOBS.NAME AS JOB_NAME,EVAL DS_JOBOBJECTS."if index(@RECORD,'POPAPPL.ANALYSIS_VERSION',1) > 0 then 'FOUND' else 'NTFND'" FROM DS_JOBS,DS_JOBOBJECTS WHERE DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO;" Question: The inner or evaluate quotes are the problem. ...

Sql without the EVAl works. #INCLUDE DSINCLUDE JOBCONTROL.H #INCLUDE DSINCLUDE DSJ_XFUNCS.H * #INCLUDE UNIVERSE.INCLUDE ODBC.H *---- Getting Directory path--------------* strStatsFileLoc = DSGetParamInfo(DSJ.ME, "$HMK_DIRLOGS", DSJ.PARAMVALUE) Call DSLogInfo("Statistics File Will be l...