DSXchange

Hi, I am new to QualityStage, So i just started learning by using the IBM QualityStage Tutorial and dsx with the given csv file. I ran Investigate job which does investigation on Name, Geographical details (City, Stage, Zip, etc.). Job has run successfully and it has created 3 csv reports. So I want...

Thanks for the response.

But i've set the key column in table as key column for Hash

Yes its works fine when it runs in sequential mode.

I tried changing the Partition to Hash but didn't work.

Hi I am trying to do Upsert on Sql Server table. But it is giving a deadlock error as below. I am running the parrel Job and ODBC stage also running in parallel. ODBC_Target,2: ODBC function "SQLExecute" reported: SQLSTATE = 40001: Native Error Code = 1,205: Msg = [IBM (DataDirect OEM)][OD...

Legacy null handling is disabled in the Transformer.

in mapping i have defined output column expression as inputcolumn and mentioned null=No.

I am not sure what i am doing wrong.

Thanks

Hi I am facing an issue with Null Values in integer field from file. What i am doing here is I am validating the null value using If (IsNull(lnk_In.col1) or trim(lnk_In.col1)="") Then "NULL" Else "NONNULL". then i put condition while loading into table only to move the ...

In My Current Process, I have written custom insert and update scripts and pasted in ODBC Stage and Selected the Key field.

Hi

I have table which has over 20million rows in it. In Source System, many rows (over 30%) are updated every day. I am using Upsert method in datastage. It is taking more time for upsert.

Is there any other method we can use to get the performance?

Thanks

Hi Source Systems have generated files with the below format Record Delimiter: LF Field Delimiter: | Quote: None Character Set - UTF-8 I am trying to load the file into Database table using Parallel Job it gives warning saying that Seq_SourceFile,0: Missing record delimiter " ", saw EOF in...

Hi I am using Bulk Insert in DRS Connector for SQL Server Database. I have executed the two Jobs one with ODBC Connector and Other with DRS(Bulk Insert) But i couldn't see any difference in execution time of both. I had seen all logs and both are pretty similar. Can someone tell me how to find my jo...

Yes You are right Craig,

But problem comes if there are any double quotes in field content. I checked it with delimiter in content it works fine. However when I try double quote in content it doesn't

Thanks

Hi We receive delimited flat files in which content has delimiter symbol(|) for few rows. to mitigate this issue, source people has created flatfiles with escape character wherever you have delimiter symbol(|). I tried finding the solution in Sequential stage but no luck. Can someone advise on this ...

Thanks Ray

One of the Third Party consultant have installed Datastage 9.1. And there was no dsadm user created bydefault. He has created new user with "dsadmin" wit h admin credentials. Is that the installation problem caused the dsadm was not created by default?

Hi

when i execute Datastage it is using my login id to execute the Job. Is there any way to set up that it should use dsadm account?

thanks