DSXchange

Strange. I dont think that datastage is the culprit. Check if default display for nulls in oracle is zero. (i assume you are running a query in oracle to check) Otherwise Try and force null into the field. If isnull(XYZ) then NULL() else XYZ I use toad to check the table. ans also I tried if IsNull...

I have a simple but big problem :) I have a sequential file as input a transformer and oracle enterprise stage as target. I am using delimited flat file and some fields are nullable, and I want to transfer those fields as null if it is null. I read one col as varchar length 7 this column is number(7...

Output from transformer compilation follows: Hi All, I got a error in parallel Transformer like PWD environment variable not set..Can u people clear this doubt? ##I TFCN 000001 09:15:21(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Softwa...

When I am trying to insert data . I am gettin this error source--flatfile intermediate stage --- Transformer target--sqlserver SQLServer_Enterprise_346,0: Failure during execution of operator logic. SQLServer_Enterprise_346,0: Internal Error: (0): odbcupsert.C: 846 can anyone suggest me what the er...

I am having big difficulties in running a simple job that I designed, it just takes a text file which I produced from MS access by exporting with delimiter | and no text qualifier. however my DataStage job cannot parse this file and abort it. The message is below, any suggestions? Event #:35 Timesta...

Somestime, if transformation are more complex who will get this kind of error. Here the Guidelines. Avoid Handling Null a lot. and convertion. Try to add one by one until you start getting this. I would suggest many modif's to avoid these kind of problem thanks for the explanation, even the simples...

Hi Everybody, I am having some problem with compilation of some of the jobs which has transformer in it. I am copying the error log below. it is a regular transformer ( not basic) in a paralle job. it gives a WARNING that the evaluation version of the C++ compiler expired. do you think it is just be...

Hi Cetin, Have you treid assigning a Null to a not null field in a transformer? I meant if you don't use a nullable field in any stage variable or column derivation expression, then the transformer can handle nulls without any problem, otherwise it would drop the records unless you use null handlin...

thank you very much Shawn. does anybody know how to make a direct connection from SQL server to MS Access?

shawn_ramsey wrote:

mctny wrote:can you please describe me how to do this?

ray.wurlod wrote:You have the alternative of accessing through SQL Server.

You can use SQL Server to create a linked server to an ODBC driver. ....

can you please describe me how to do this?

ray.wurlod wrote:You have the alternative of accessing through SQL Server.

I don't know of an MS-Access ODBC driver for Unix. One method is to use a SQL-Server database and connect the MS-Access mdb to it, then use the SQL-Server ODBC driver for Unix. I also need to access to Ms access from Datastage PX ( 7.5.1A) in Unix ( IBM AX 5.3), if using intermediate DB ( Ms SQL se...

Transformers can handle null values without any problem, you don't need to use any null field value etc, however sequential files cannot handle nulls by itself, you need to handle by yourself. ( use special null value as suggested, )

It depends on how you configured the Sequence. If you had give the $PROJDEF in JobSequence, it gets the value from Project level setting. Since, JobSequence is the point where the whole parameter value is been passed, your assertion will be right. If by chance parameter doesnt match each other, the...

sorry the sentence " when I go to the job, and view data in the sequence " should be "when I go to the job, and view data in the stage " I am not entering anyvalue when trying to view data on the stage, the password comes by default. when I checked the sequence parameters I saw t...

Thank you for the explanation, I am still having problem, with accessing SQL server DB ( ODBC stage) through DS PX job which is called by a sequence, when I go to the job, and view data in the sequence, it works fine and I can view the data, when I run the seq, it says username/password not correct,...