DSXchange

.odbc.ini is located in your DataStage server where as Tnsnames.ora file is located in your client machine. Nope - at least not in a DataStage discussion. Both must be on the Server. ok sorry, you are right, I was thinking when I am trying to connect to another oracle DB in another server, I need t...

.odbc.ini is located in your DataStage server where as Tnsnames.ora file is located in your client machine.

I think you can call your main sequence in a unix script but you have to write one or find one written, I am not that expert in writing a script to run a datastage job but it is not that hard. search the forum or internet. The idea is to just call the main sequence in a loop that try to run it as ma...

via wrote:Thanks all.
...the activity will be logged. ......
..

No the activity is not logged. As the Gurus said, the only option you had is to bring the job from the backup (or the second option would be to recreate the job )

can someone explain how to install it on windows? do I have to install cygwin or can I do it in Ms Dos prompt? will I use the last code that is written in this thread or will I use both, ( i.e, the last and the second from the last) ?

Hi all,

so does this DSX cutter work for version 7.1, i.e., jobs designed with DS version 7.1 server edition and exported into a dsx file?

One possible reason could be the number of warnings to abort the job, in director, when you run a job the default number of warnings before the job is aborted is 50. however when you run the job through designer, there is no limit on the max number of warnings, in this case if your job is producing ...

Helloo everybody, we have alot of parallel jobs that has basic transformers in it and also read and write to the same table in the same job and those basic transformers are causing problems all the time in development and test environment, I would like to replace all the basic transformers with the ...

what do you want to do ? you don't need DataStage to convert an excel spreadsheet to a flat file. just save the spreadsheet as a csv, if you want a different delimiter other than comma, open the csv file in notepad or wordpad and replace all commas with your desired delimiter. after that you can sav...

nitin376 wrote:How to turn spread sheet (xls) into a delimited flat-file ?

you can save the file as csv ( coma delimited) or tab delimited or unicode text.

Hi Kumar, I agree with you. Nulls should be tansferred as nulls if you don't do anything. I solved the problem using unknown data type in the right side of the mapping of the transformer. I have to use transformer anyway, because of other fields ransformation. as far as I remember, when I view the d...

I guess this is what is happening. Oracle accepts date format in YYYY-MM-DD HH24:MI:SS. So, I guess you need to prepare your input data in that format before you load it into Oracle. Convert the Varchar into Timestamp in a Stage Variable and then parse the Timestamp into the required format using D...

Hi Kris Thank you very much for the advise. I am using the first one you suggested, however it doesnot work ( gives the run time error I posted in my previous post) the second one you suggested is not what we want because we need time as well as date. In the left side of transformer, I defined that ...

I am also having similar problem and haven't figured out yet even though I searched the forum and read several thread. I would appreciate if someone help regarding date conversion issue. here is a detailed description my source is a flat file which is delimited text produced by exporting a table fro...

when I load the target table I see that the nulls at the input are transferred as zero, I couldnot make it null no matter what I tried. any ideas? Are you sure you are looking at the same record in source and target? You get 0's when you move from varchar to NUmber field if it has any non-numeric d...