DSXchange

I am thinking of creating a buildop stage which can do the like operation.

which can have one input and one ref. link.

Am pretty new to the build op stage...can any one advice me on doing it...




thanks in advance

Rakesh

yes it is
you have truncate command in orchadmin

go through 'orchadmin man'

regards
Rakesh

Hi Guys, I have a requirement to do Like operation between two columns in two files. We have to do all types of like such as inputColumn like '%Ref.Column' inputColumn like 'Ref.column%' '%inputCoulmn' like Ref.Column etc. Since both the input and ref file contains large volume of data, joining and ...

Hi guys,

Is there any settings(tuning) to be done for increasing number of rows inserted per second while directly loading to the SQL SERVER database.

Thanks
Rakesh

Thanks a lot Ray....Resolved it..

Hi, I have written an C++ routine whose return value is char*. For rows up to 30000 its working fine as expected. But when more than 30000 records came its showing error as Fatal Error: Subprocess appears to be writing binary data as error messages. 131072 binary bytes written to stdout or stderr of...

Hi

I am also experiancing same issue.
Can you guys help me in resolving this?

Thanks
Rakesh

Mistakes :oops: Mistakes :oops: Sorry guys... Craig thanks for your reply.... I had tried by finding the Ascii value of those Character..but its not working as expected... And when I set the $APT_STRING_PADCHAR to 0x20 the columns with at-least one character's value is coming perfectly. But if there...

Hi I am fetching data from an CHAR(5) COLUMN of an SQL SERVER 2005 database.If the count of number of characters in that column is less than 5,then am getting some unknown characters for the rest... Example Column1 AA^@^@^@ aaaaa b^@^@^@^@ This Unknown character(^@) is not visible from datastage(whi...

thanks Ray,

I use the VS Script and call that by using the execute command...i felt its working fine..

HI,

To read data from EXCEL File we have to option of creating DSN and converting to csv file.

Here I opted for the second one ie ,converting into .csv file.

Can you people guide me on how to do that other than manually converting?

Any batch script can be use for this requirement??

Thanks

Hi, In Dynamic RDBMS stage in General properties of Input, we have an option called Update Action There we have Bulk Insert and also when we select this , It shows some some other option called as BULK with some properties There it is asking for commit size and also mention it should be greater than...

Thanks Ray for your time...


I tried it with using bulk insert option of the RDBMS stage.....

I can see am improvement in the transaction, ie records are passing at a speed of 17000row/sec.

But for committing again its takes lot of time.
I kept commit size as 10000

Thanks
Rakesh

Hi I want to insert more than 2 million of data to a SQL Server database. The source is a flat file Then need to do some sort of Transformation using a transformer. Then need to load in to MS SQL database. In datastage can anybody suggest me how to use bulk insert...please give me some detailed info...

hi all
but there is no limit for the count of values in cl3.It can be any 'n' numbers separated by " "(space).

Thanks