DSXchange

This works

TimestampFromDateTime(StringToDate(lnk_Date.Date,"%mm/%dd/%yyyy"),"00:00:00")

Thanks
Pavan

When I tried the StringToTimestamp, I am getting this error message, APT_CombinedOperatorController(1),0: Data string '03/10/201200:00:00' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': the value for tag %yyyy has fewer characters than expected. StringToTimestamp(DateToString(DSLink2.da,"%y...

The data is coming in the form of a string not date. I apologize for my previous posting. I tried with TimestampFromDateTime and it is not working. APT_CombinedOperatorController(1),1: Data string '03/23/2012' does not match format '%yyyy-%mm-%dd': the value for tag %yyyy has fewer characters than e...

The data type is date

Thanks
Pavan

The incoming date format is : 04/05/2012

I wish to convert to Timestamp. (add zeros to the end is also fine)

Thanks
Pavan

Hello,

I have source where the date is coming in the format 04/05/2012

can somone please tell me how do I convert this date to timestamp.

Thanks
Pavan

Hi All, I have incoming data coming in separated by space such as, america italy spain india america china britan japan desired output: america i.e. I have to pick up only the 1 one and process it. Can anyone please let me know how do I process data separated by single space. sometimes the data can ...

here is the control file, { node "node1" { fastname "server1" pools "" resource disk "/opt/IBM/IIS/dstage0" {pools ""} resource scratchdisk "/opt/IBM/IIS/scratch0" {pools ""} } node "node2" { fastname "server1"...

I have a datastage job writing a fileset as output. The job is running on 2x1 configuration file.Whenever the job run it fills up the space to 100% in dstage0 directory first and then the job aborts. I verified and there is no hard coding in the job to write into the dstage0 first. Can someone pleas...

Can someone please let me know how can I perform pattern matching in datastage. I have a string such as "capital city is AUSTIN" I have to find if the incoming string has "AUSTIN" (always in caps) and if it find a match then write "AUSTIN" to output. Thanks & Regard...

There will be only 1 record in the oracle table (lets say table name is myz) whose Col D has selct query. The select query in Col D is not querying the same table. The select query will return 3 columns. The query is static for now, when there is a change, it might be in the "where" clause...

Hi All, I have a unique situation where a sql is stored in Oracle table. The table has 4 columns, colA, colB, col C and colD. The sql is stored in col D in the table. sql statement in Col D might be something like this, select xxx,yzz,ymz from table xx where condition 1= condition2 datastage has to ...

I am running 4 instances of the same job and each instance writing its own output. (different data, different o/p name of the file)

They are not writing to the same sequential file.

Can someone please let me know how running multiple instances of the same job vary in utilizing the resources such as data stage server/memory/input output throughtput perspective. I have a job that runs on 2x1 configuration file and completes in under 5 minutes consistently. The job is processing a...

Actually the file will be local to the datastage server. where can I find the sql file option in the Oracle Enterprise edition stage.

Thanks
Pavan