DSXchange

You can create different config files with different number of nodes (single node,2 nodes,4 nodes) at the fallowing location /opt/datastage/Ascential/DataStage/Configurations on your UNIX box and use these different config files for different jobs in same project using the $APT_CONFIG_FILE environme...

Hi,

I havn't got knowledge about XML input stage ,But one thing i can say is that you can insert a copy stage after XML input stage and explicitly select the key columns from copy stage output

What you are trying to do actually?

If you want to join 2 tables then how do u want to join those tables i.e. left join or right join or inner join?

first go through the datastage manual and read about join,merge and lookup stages.

Go through the links below may help you:

viewtopic.php?t=112093&highlight=premature+eof+node

viewtopic.php?t=111660&highlight=premature+eof+node

Do not include group type columns in metadata

You can directly load the metadata from table definitions in FTP plug-in stage

the mainframe layout shown in your post itself is copybook
if it is a text file,then you need to save it as .cfd extension file

make sure that the cfd file to have 01 level in eight column

better go to google n search for cobol file definaition and you'll understand well the cobol file format

In Datastage Designer go to the repository then right click on table definitions--->import--->COBOL file definitions then it'll popup a window to select copybook relevent to table definition, select copybook and import tabledefinition.

Thats not correct!

Here is my answer:

Please_Convert_My_Date("MMDDYY","CCYYMMDD")

You can use copy stage before the sequential file stage then you can handle nulls for the rejected records in the sequential file.

You have mentioned all fields as not nullable. So you need to mention the default value for those not null fields in the sequential file stage iorder to read it properly. you can set the default value for the fileds in seq file stage by clicking in front of columns in columns tab page.a new window w...

Munish,

Just use either transformer or modify stage to trim the input columns coming from input dataset instead of lookup.
If u have any more doubts, let me know

How to set up repositories in Metastage. (Does that repository mean the metastage directory?) You can directly create a database schema specific for metastage metadata in your database to store all the metadata imported using metastage i.e metastage repository . whenever you login to the metastage ...

HI,
as said by the others indexing also affects.
better to use DB than DS.

My suggestin is while populating data into Prd Db use Std Prc stage and write a proc apply ur NVL functions which wld be better i think

chk it in Toad sql editor