DSXchange

ray.wurlod wrote:You shouldn't need to remove the dashes. However, since YMD is not your default locale setting, you need DYMD in the Iconv() function. Also, it's a space, not a dot, in the G conversion.

Ray,
Thank you so much for the information. I will make these changes.

Seyed

Hello Ray, Problem is resovled. After removing dashes and time from the timestamp, I was able to get your suggested code to work as well. Here is how I got your suggested code to work: OConv(IConv(Change(DSLink1.LOG_DT_TM[1,10],"-",""), "G0.1" : @VM : "D"), &q...

Craig, The problem is resolved. I followed your instructions and identified that the problem was in the Iconv routine. It turns out that I had to remove dashes from the date. Here is how I got your suggested code to work: OConv(OConv(IConv(Change(DSLink1.LOG_DT_TM[1,10],"-",""),&...

It sounds like a great plan. I'll see if I could isolate this problem following your suggestions and let you when I identify the problem.

Thank you very much,

Seyed

Hello Craig and Ray, I just finished trying the following methods none of which worked. I am pretty sure that with the first two methods, the time has been removed from the timestamp. OConv(OConv(IConv(Field(DSLink1.LOG_DT_TM, " ", 1,1),"D"),"DMA"),"MCT") OCon...

Hi Craig,
Thank you for your help. Below is a sample of date coming in:
Thanks again,

Seyed

Hello Ray,
I tried the following code, it didn't populate the column.
Am I missing something here?

Thank you very much,

Seyed

Hi Craig, Thank you for your help. I tried the following code, but didn't get anything loaded into the table. The recieving column remains empty and no errors are generated. I even tried writing the result to a sequential file, the same result. OConv(OConv(IConv(DSLink1.LOG_DT_TM,"D"),&quo...

Hi all, I have a DataStage Server job. I want to extract a month's full name, example, January, February, etc from it. What is the best way to do this? Out of desperation, I tried the following function, but learned from one of Craig's postings, that this format string belongs to parallel jobs. Date...

Assuming that attempts are made to first insert the rejected data into the Oracle table and then to the rejected file ps. Not an assumption... How It Works. :wink: Hi Craig, I resolved this problem by adding the following constraints in the Transform Stage: DSLink1.CL_USR_NM = DSLink5.WRKR_USER_ID ...

Assuming that attempts are made to first insert the rejected data into the Oracle table and then to the rejected file ps. Not an assumption... How It Works. :wink: That is good to know. Thanks, by the way, I checked and verified that neither the WRKR_DMSN_ID nor DIV_DMSN_ID columns in the lookup ta...

Hi Craig, Thank you for your input. Assuming that attempts are made to first insert the rejected data into the Oracle table and then to the rejected file, what would be the solution? Below is an example of the error messages being generated: Project:AgencyWideReports (sabcdef) Job name:Load_TWRKR_DI...

Hi all, I have a problem with a Server job. My source table, target table and lookup tables are in Oracle. I wanted to read the data in the source table and then find a matching data in the lookup table. If the lookup was successful, I would insert data in the target table. If lookup failed, I would...

Nagaraj wrote:

Code: Select all

 Oconv(Iconv(DSLink4.LOG_DT,"DMDY"),"D-YMD[4,2,2]") : " " : Oconv(Iconv(DSLink4.LOG_TM,"MT"),"MTS") 

this should work, i did the same thing it works.

Hi Nagaraj,
I tried your suggestion and it solved my problem.

Thank you very much,

Seyed

And you'll need to specify a second argument for the Oconv() function applied to the date component, not the two components. Nor do you require a 12-hour clock in a timestamp, so lose the "H" from "M ... Hi Ray, Because the target column in the Oracle table is defined as Timestamp(0)...