DSXchange

Can a datastage job can be created as a web service so that it can be called from within a java code?

I have 3 job activities which are to be run in a sequence..........one of the simplest jobs... The problem is that 'm in a dilemma where to use the terminator stage? with the exception hanler or with the job activities? or both? Is there any sense in using terminator stage twice in a job? Is excepti...

@ chulett @arndW I have successfully created the exported.isx file in the server and place yhe file in my local folder usinfg ftp.
Then when i'm trying to extract that using 7zip it gives me error saying that "can't open file <filename> as archive.

@asingh Did you suggest to rename the .isx file after generation or put the .zip extension in the command itself.

I can export the jobs using istool command with .isx or .dsx format.but not been able to import those by designer.It said that the file is of unsupported type & can't be imported.

@harini Using istool command can help you in taking the backup of jobs folder wise
provided that you are using datastage8.1 and the advanced patch is installed.

@chulett Thank you. Just want to add a few things as the topic you have pointed is resolved. someone pointed out earlier that if the password contains '$' a backslash needs to be infront of it. I don't think it is needed.I'm using a password that contains a '$' and without the '/' it is working fine...

asorrell:: As you have pointed out earlier that if the password contains '$' a backslash needs to be in front of it. I don't think it is needed.I'm using a password that contains a '$' and without the '/' it is working fine for me. and I guess if I am using istool utility to export assets I must use...

Hi
I'm trying to export certain jobs from datastage using istool command.I'd like to know if .isx must be used in the file extension while using istool command?

Even it is not so can anyone share light on how to import from a .isx format to the datastage

This is definitely because of the lack of the proper null handling in the transformer stage.go to the transformer stage , in the column metadata and double click on the column number,a new windows pops out where you can set the null field value. ideally these should be done for all the columns havin...

Please don't misunderstand me.I understood the 'u' part. and I'll keep that in mind.

@ray;@chulett :I am extremely sorry for my previous post. :oops: Basically I misunderstood ray's post.Now I get the point.I'll obviously keep that in mind. :) The main question in the post was that transformer is not supporting column name containing '-'.What I was trying to say was that in database...

@ray: can't get you properly what you have said about that 'DB2'.I'm sorry if I miss any topic related 'formalities of posting answers'. I wonder If there is any syntactical checking is done on the answers posted here...less bothered about the 'second person personal pronoun in English' or that sort...

there are some confusions. I don' know how 'Append' mode is checking for the previous data that was inserted.It shouldn't do this unless there is a unique constraint on that specific column.Use 'truncate' in that place. Ideally in datastage if the job aborts the rows should be rolled back.but it is ...

I fear it can't be done.
datatage can't process column names having '-'.
In oracle u can do it. but even then datastage will not support that column

Can anyone please refer to any document(such as white paper,pdf)