DSXchange

Hi all,

I need to connect my DataStage to an Interbase 5.6 database. Does anybody already does that kind of connection ? if yes, by which way you did that successfully ? (which driver (ODBC or JDBC) do you use ? etc.)

Many thanks

You can use the command line from the ADMIN tool or straight from a UNIX shell (that would be "dssh") and execute a "LIST {filename}" with DS Syntax or use SQL syntax with a "SELECT" statement. ... I tried that and this is what i get : DataStage Command Language 7.5 Co...

Hi all,

Is there a way to view an hashfile content without using the designer client ? I'm asking that because i really need to check its content in my production environment and I do not have a designer access to it, naturally !

many thanks in advance.

Best regards

Hi all, After installing the fixPack 1 (8.1) it's become impossible to launch any IA analysis on my platform. I always get the error : Error loading "pxbridge" : could not find "pxbridge" on the the library search path defined by the environment variable PATH ... NB: I've check t...

If the conversion can't be done then a null is returned - so you have just masked the error and not solved the real cause. ... True, my problem is not solved at all ! that was just a way to find where the issue is ... i can conclude that the int32_from_decimal returns a null value now : so, normall...

That looks strange. Can you put a transform stage in there and attempt a type conversion on DSPROJECT_ID there for test purposes? ... I tested another thing : i've change the formula with : DSPROJECT_ID=handle_null(int32_from_decimal(DSPROJECT_ID), '0') And it works !!! but that should not work ......

Hi, In a modify stage i've put the formula : DSPROJECT_ID=int32_from_decimal(DSPROJECT_ID) NB: DSPROJECT_ID is an oracle NUMBER(5) type and not nullable. Each time i run the job i get this error : APT_CombinedOperatorController,0: Un-handled conversion error on field "DSPROJECT_ID " from s...

The RAID debugger is the only debugging tool out there for BASIC programs, there is no graphical tool available. With some large job control programs I found it easier to save it into a file and compi ... Thanks but can you give me more light ... 1) you create a UniVerse file with > CREATE.FILE (ty...

Never EVER do an UNLOCK ALL in UniVerse unless you know exactly what you are doing. This removes all levels of locks from the whole system and can mess up many things, particularl ... Right it can be dangerous ... but ... do we have a better solution ? If i remember the command unlock accept the ex...

Hi, i am getting the below error when connecting to oracle from datasatge using OCI stage. Working on windows with parellel edition(DS 8.0). ##I IIS-DSEE-TOSH-00002 10:39:17(001) <main_program> orchgeneral: loaded ##I IIS-DSEE-TOSH-00002 10:39:17(002) <main_program> orchsort: loaded ##I IIS-DSEE-TO...

i have complex job using more than 20 stages, when i ran the job and it is locked .after that i have try to kill the job but still its showing job is accessed by another user my i know root cause of this broblem.plz help To unlock a job (in version 7.x because in the 8.x it's different) you must in...

Does anybody has an idea to debug a job control code (basic). I have a very big job control code (several thousands lines of code of basic and without comments) to understand and it's very complicated to follow the code without executing it step by step ... It's written on the doc that we can use th...

nirdesh2 wrote:I think this parameter is used $APT_RDBMS_COMMIT_ROWS DB2 database. Still it is not considering this parameter values for commit.

The settings of this variable apply to the supported parallel database engines : DB2, Teradata and Oracle.

You'll need to provide more information than that unless you want lots of guess work in the answers you receive. What else do these jobs that are running slowly do? Define slow. Is anything else running on your two systems when you measure the performance of these jobs? Is the disk subsystem the sa...

Hello All, Thanks in Advance In my source data i have distinct date formats as yyyy-mm-dd, yyyymmdd, dd-MON-yy and d-MON-yy. My source field is Varchar2(60). I want ETL to standardize all this it to yyyy-mm-dd format. If any other date format is found, pass it as default date(0001-01-01) Please pro...