DSXchange

Hi ,
viewtopic.php?t=117993&highlight=.dsx+and+.xml

Hi Ravi,
have you tried convert function in transformer ?
try this one
Code:
Convert('"','',column name)

Hi Siva,

dsjob -ljobs <Projectname>
then you will get your project jobs in list .

Hi miwinter,

thanks for the reply,in sequential file we have option "Read first Rows" like this also we can filter the records right?

Hi all,
thanks for reply

if i'm wrong please correct me
i have used "Filter" option in sequential file in that i have used unix command. is there any process is there ?

Hi All,

Could you please help me how can filter the records in sequential stage?

Hi DWH-M,
thanks for the reply
i have tried to delete but not able to find delete option in Datastage Manager .(tools...>Dataset management..>)
Could you please help in this

Hi all,
How to Delete Dataset in Datastage Parallel Jobs?

Hi Sunitha,

This link has the objectives of the test

http://www-03.ibm.com/certify/tests/obj415.shtml

Hopefully It may help you.

Thanks
fareeda

*Note: Topic Relocated to General - Content Editor*

Hi Sunitha,

This link has the objectives of the test

http://www-03.ibm.com/certify/tests/obj415.shtml

Hopefully It may help you.

Thanks
fareeda

Hai ,


viewtopic.php?t=118781&highlight=CRC32

Hopefully it will help you .

Hi All

i need to know about the user varible activity stage. Actually i need to invoke the one varible value which is there in other job.In a sequence i need to get this to compare the varble value.

So help me in this.

Hi Kumar, The DB2/UDB Enterprise (native parallel) stage should be used for reading from, performing lookups against, and writing to a DB2 Enterprise Server Edition database with Database Partitioning Feature - As a native, parallel component, the DB2/UDB Enterprise stage is designed for maximum per...

Hi arun,

The Lookup stage is most appropriate when reference data is small enough to fit into physical (shared) memory.
Limit use of Sparse Lookup(for DB2 and Oracle reference tables)

For reference datasets larger than available memory, use the JOIN or MERGE stage.

thanks
fareeda

Hi braj,

Try this Field(column_name,"@",2)

Example :
column name:Z@CTCD

special character position is 2

Field(Z@CTCD,"@",2) it will work in transformer stage

Thanks
fareeda