DSXchange

I am converting some date fields from our default of 1900-01-01 to the empty string (''). I am writing them out to a sequential stage with a datatype of date nullable and a format of %dd/%mm/%yyyy. They are beng written to the file as **********. I used to do a SetNull on the fields but thought mak...

Hi
You can take the backup of your jobs by using the import/export facility in Datastage Manager.

Regards
Ashwin

You can do version control in datastage using Datastage Version Controller.

Regards
Ashwin

Hi

If you are talking about the reference file for you lookup then I think, Datasets will be better than Database. You can even go for Lookup Fileset as Reference files for your lookups.

Regards
Ashwin

Hi Can somebody please guide me that what will be the simplest way of converting a Date from ccyy-mm-dd format to dd-mon-yy format. For example 2006-02-12 as 12-feb-06. It can be done in transformer, using some stage variables and if-else loop, I wish to know if there is any function or combination ...

First check if the project is a protected one, this you can check in Administrator client.
Administrator or root user can unprotect a protected project. You can do this and then make the changes.


Regards
Ashwin

In sequential file stage, check Options you can find Schema file. You can give the path and name of the file which holds the schema.
Example is

record (
empname:string[255];
address1:nullable string[255];
address2:nullable string[255];
deptno:int32
)


Hope it helps.

Regards
Ashwin

About Datastage Architecture- It follows Client and Server Architecure Client Components - designer, director, administrator and manager Server Components - DS Engine, Repository and Package Installer To capture data change - you have to use ChangeCapture and ChangeCapureApply Stages SCD can be impl...

Yeah Kumar you are right.

But the column name eno, ename, sal create some confusion and the way its writen in source and target.

eno ename sal
1 a 100
2 b 200
3 c 300


eno number 10
ename char 2
sal number 10

Regards
Ashwin

Hi Cetin

I had faced something similar. Though I am not sure about the exact reason for this error. It may have something to do with the disk (resource and scratch) space.

Regards
Ashwin

It will be easy for us to help you if you can explain in brief what exactly is the problem.

Regards
Ashwin

Hi Chandra

I think you should go through user guide and read about shared container creation. Also search the forum for shared container, you will find many posts.

Regards
Ashwin

Try NDM from Mainframe to Unix Box. I guess it may help you.

I think that you should ensure that you are defining the right metadata, and that you are not attempting to create data bigger than what your field length is. Check what you did in your transformer stages.

I am sorry about that, didn't see the job type

My Apologies.

Ashwin