DSXchange

Thanks John for the reply... But still interested to know if separate pop up windows are achievable in DS

Hi All, Thanks in Advance for reading this post. Is there a way to achieve custom pop up windows ther than the " Job Run Options" window in Datastage whenever we try to run a job . For example: In Windows/Unix If you want do delete files, it will prompt or give a pop up window saying "...

Thanks for the reply Ray and appreciate the idea of reading from file \n as delimiter. First of all, let me be more clear on the purpose of this job. Sorry for not being so earlier. This job will be run on an Adhoc request in Production environment. Most of the times I did not face a problem just ha...

Hi, We have a requirement where we need to pass value as parameter for the Before/After SQL in Oracle Connector. This value can be a DML statement or a Procedure/Package call and these statements are not limited to one table/procedure. The statement in general contains multiple lines and so i have t...

The document root should be the top level element that you are parsing. Lets say if there is a envelope, header and body in the message. If you want to parse the Envelope you should select Envelope in the root and in the next parse step if you want to parse the header then you shiould choose Header ...

Does the export contain only the executable, not the design components? ... Thanks for ur reply Ray. To go in Detail, When we load the FpML 4.9 version files Schema Lib Manager is accepting (as it contains root element). But coming to 5.2 version the FpML does not have a root element. That's why th...

Hi Everybody, We have a job in which we have to import FpMl 5.2 files/Schema. But, When we import it is being imported but when we are trying to validate, it is showing an error message that root element is missing. Does anybody know how to fix this? Any help regarding this replies will be appprecia...

Hi Karthi,

If I am getting it right. You want to apply SQL code in your ODBC stage

from a .txt file.

I think there is an option in the Stage Tab to mention the SQL from file. Pls check the developers guide..........

Yeah Pivot can help

I think that there is no need to go for training into enterprise if you want to develop and design in server, and yes there is a lot of difference.

Hi all, I have to monitor disk space for the datastage projects on development and production on unix servers daily, I am generally using the commands to monitor disk space, but just to make the job easier I am just thinking of a shell script that would automatically generate a mail to me every 3 or...

the method you are using is very easy and mostly i am doing in the same way

hi i have a job in which i have a cff and there is no metadata for that and when i am trying to view the data it's not readable data and as it cff it is separated by commas(CSV), and i want to put tha data after comma in next row and so on. can u guys suggest which stage to use to split or we can do...

what is a pcard

hai
i just have a problem here guys
i am getting an empty row as the first row when i use the sort stage and i want to delete it(imp thing is there is an empty in the input file)