DSXchange

The input data type is a character and I am converting it to a date column in this format (YYYYMMDD). However, the OCONV function still put the dashes in the output. I do not want the dashes in the table. That is what I am trying to do. Also the DIGITS function output looks like this: 9811-06-11) s...

The input is coming from character field like this: 20041030 I'm a little confused as well. :? This seems to match your desired output format and would (usually) mean no conversion was required. So, what are we missing? For what it's worth, DIGITS is a Built-In Transform that simplifies the call to...

My Oconv returns date like this 2004 08 20 Then this should work fine too: Trim(Oconv(LinkName.DateColumnName, "DYMD[4,2,2]") , Space(1), "A") But the question is: what is your input value look like? Oconv input shoud be integer. What does this "A" mean? This changed t...

leomauer wrote:My Oconv returns date like this 2004 08 20
Then this should work fine too:
Trim(Oconv(Arg1, "DYMD[4,2,2]") , Space(1), "A")

But the question is: what is your input value look like?

The input is coming from character field like this:

20041030

ketfos wrote:Hi,
Try using Ereplace function as shown

Ereplace((Oconv(LinkName.DateColumnName, "DYMD[4,2,2]")),"-","")


Ketfos

Thanks for showing me the Ereplace function but that did not work either.

chulett wrote:You could use:

Code: Select all

DIGITS(Iconv(LinkName.DateColumnName, "DYMD[4,2,2]"))

I believe it always wants to add a delimiter to the date. This uses a Transform to strip out all non-numeric characters.

The dashes are still there. How do I get rid of the dashes? thank for your help!!!

Iconv(LinkName.DateColumnName, "DYMD[4,2,2]")

The following code example returns the date in this format: 2003-10-01

How do I modify this to return it in this format: 20031001?

This is the query that I am trying to emulate in DB2. The problem is the date columns. The 2nd query in the union uses the DOC_TERM_DT column but it will only use that one if the DOC_TERM_DT is the MAX(DOC_TERM_DT) and equal to the other other key columns as seen below. How do I do this in the trans...

Is the primary key of your hash file composed of all six columns, no more and no less? In your job, all six lookup key columns should have derivations. Key columns should not be disabled. You noted the string Position Number in your error message. Is this a column name in your hash file? Does it in...

Input File (8 keys) -------> Hash file (link to 6 keys) -------pull Position Nbr based on key joins --------> TARGET ODBC DB2 table. What is happening is that the join from the other columns are not displaying in the HASH file object unless I disable the primary keys, however, when that is done then...

ogmios wrote:First check is to see whether the primary key of the hash file is stored in exactly the same way as the field that you get from the other input (no trailing spaces e.g.)

Ogmios

I trimmed everything but still no data.

What is the difference between a Server and a Parallel job?

I'm hoping someone can help me. I'm having a simple developer issue on trying to get one field to populate in the target table. Basically, I'm loading a flat file to a target table, but want to grab one more field(which is a key field in the target table) for the target. The input file has 6 primary...

I'm hoping someone can help me. I'm having a simple developer issue on trying to get one field to populate in the target table. Basically, I'm loading a flat file to a target table, but want to grab one more field(which is a key field in the target table) for the target. The input file has 6 primary...