DSXchange

Hi All,

Thanks all for your inputs....

It's got resolved...

Hi,

In my project,I have a requirement like this.

Once the job finishes successfully, my input file needs to be cleared and it should be empty.

Can any one please help me on this.

You can split the logic in dd/mm/yyyy or dd/mon/yyyy as below In both cases: yourYear = MatchField(yourField, "0X4N0X",2) In mon: yourMonth = MatchField ...[/quote] Hi Sainath, Thanks a lot for your solution. Right now I am working on your solution,for month part you have given saying tha...

Based on your sample, the date is always the last three space-delimited fields or the last one if it is of the form nn/nn/nnnn. Extracting them should be reasonably straightforward; for example a ... Hi Ray, Could you please let me know how to do pattern matching (to search the date in a string)

Based on your sample, the date is always the last three space-delimited fields or the last one if it is of the form nn/nn/nnnn. Extracting them should be reasonably straightforward; for example a ... Hi Ray, Thanks a lot for your inputs. But here my problem is date may be in any position in a strin...

Hi, We have a requirement like this. My Input is like this. 01.000% MAY 28 2009 DUE JULY 24, 2014 PR=110% DUE 03/05/1999 08.180% MAR 30 2035 10% DUE MARCH 15, 2009 We want to extract a date from the above strings. Date may be in any position in a string. Expected Out Put should be: 2009-05-28 2014-0...

Hi, We have a server job, which loads around 10,000 records from Oracle table to UDB-DB2 table; this is on HP-Unix with ODBC 5.3 drivers into. We are using the DRS stage to read and write data. This job is consuming 14 minutes to complete, where as previously with ODBC 5.2 drivers it was taking 7 mi...

Hi All, I am facing a strange problem with DRS. I am trying to connect to Oracle through DRS using ODBC connection. The password parameter which I am mentioning is of length-37. So, when I try to view the data/Run the job. I am getting the error saying that "Invalid Username/Password". Tho...

Hi, I should request the client to enable the firewall for all the servers which we are using in our project, hence I have to provide all the ip address and corresponding port numbers. We are using UNIX as the operating system and DataStage 7.5.2 (server jobs), can any one please help me to identify...

I am using DRS stage in a one to one job; both the src and tgt are DRS stage. When I try running the job, in the source stage I am facing the following fatal error. PS_SH_PRIORWORK_EXPER_Job..PS_PRIORWORK_EXPER: Client Library property required for stage Can any one help me in solving this issue :?: