DSXchange

You should look at record wise but not column wise

I mean compare 1st record with s2nd record..

Before you push data into aggregator stage, Use a sort stage.

In sort stage you perform the sort operation

Attu,

Command:

df -k .

Output:

filesystem kbytes used avail capacity mountedon

You need to look at capacity which is in terms of percentage

Good luck

1. Select count(*) from table_name;

Look at the log to find

rows read
rows written

any constraints in job?

Create Multiple Instance job

ODBC--->Transformer|---->Hashed File1

Job1: Dump data to hashed file( 4 different hashed files)
job2: Now perform your look up operation

Pradeep,

How does the design look like.
What are the keys.
Is source a hashed file.
Based on which key, you are performing join.

Thanks

every thing looks good, i created a test column to check the output leaving the original one, the warning is regarding the original column.

Thanks sachin

sachin1 wrote:your formatting is wrong i think please can you check my previous post

I am getting warning messages test..Sort: At row 1, link "DSLinkxx", while processing column "DT" Value treated as NULL Attempt to convert String value "20080709" to Timestamp type unsuccessful Input souce column datatype is varchar if you are inserting the value in dat...

How to convert string value to timestamp

ex: string value(yyyymmdd) 20080709

Thanks

"Select the shared container -->Tools -->Usage Analysis"

kollurianu wrote:Thanks Craig !!, now got it how to use it.

ArndW wrote:Aren't the MKS Toolkit components installed automatically anymore? ...

Its installed, But the question is how to get into unix windows.

Hi,

How can i run unix commands in windows in version 8.0

Thanks

Hi,

1. Can any one let me know how to configure DB2 on version 8.0.

Thanks