DSXchange

Nope, its not a disk space problem. Its acutally a bug in datastage, we managed to work this out already. There were some jobs that have the same name but different cases, DS server allows this but the export executable job window list does not, meaning its not case sensitive when it creates the key...

Hi All, Would like to know if anybody out there has ever experienced an automation error (run-time error -457) when exporting job executables in manager? We tried moving the designs to a new project, compile then export executable but still it happens. If exporting a folder with 1 job, the windows a...

Hello,

You write PX routines using C. Once finished you compile as a library and then define the function in manager. There are sample programs in the installation cd.

HTH.

Hi All, I'm having a really weird problem in DataStage. Am trying to find out why there are some records that datastage could not find inside my table even though those records are existing already. When I do a query using SQL the records are returned, but when I run my DataStage job these input rec...

Hi,

We're creating 3 different projects: DEV, SIT, UAT on one box and would like to know if PX can be configured so that each project will have a specific node assigned to it.

Thanks.

Hi All,

Is there any way to configure PX to run 3 different projects on 3 different nodes? Meaning each node is exclusive to 1 project only?

Thanks.

record should be something like:

"Agent", "Agent", "Regular", "GG042", "E3", ">64", "25-36 months", "Male"

Now I'm thinking that because of this I'm having some records being rejected when passing thru a lookup stage.

output of data looks something like this.

"Agent","Age"00008958",,"Regular","GG042","E3",64","25-3"H",n" 000001.","00006951"

Hi, We currently have something similar to this problem, difference is that we cannot access the job designs in our development (no design information). Suspect that this happened because our disk usage hit 99%. Tried rebuilding the index but did not work. When I use the LIST DS_JOBOBJECTS command i...

Hi all, I'm trying to output data into a sequential file. Problem is, some or most of the fields in the file are garbage. I've tried setting all values to "0" but still gives me the same thing. However, when I output it to a dataset, everything looks ok. Anybody encountered something like ...

ray,

thanks for the tip. :D

Hi All, Have a problem regarding ODBC DSNs. We have installed the Data Direct drivers for SQLServer in Unix and have configured the .odbc.ini and uvodbc.config accordingly. We can see the DSN name inside Manager and are able to get the tables. However, when we use the ODBC stage in the designer, the...

Hi, I have already created a metastage schema "mtstgdev" and have successfully made a DSN Directory via Oracle ODBC "MS_DVMITW". But when I was trying to login in MS Explorer using the username "mststgdev" and password "mtstgdev" I created for my schema, MS di...

We are currently working on an extract program wherein part of the input are fields where the picture clause contains a negative or positive sign [ex: PIC -9(7)V99]. In traditional COBOL, this is a valid picture clause for numeric literals. During the copybook import process in DataStage though, thi...

hi all, we have bumped into trouble where the numeric data is being rounded off by datastage. e.g. PIC(15) is defined 123456789012345.99 * 0.1234567 = 123456789012345.123456789 we need all the 22 digits for use by the other computations but datastage is truncating and rounding it off making varying ...