DSXchange

I think we ended up manually changing the data on output in a buildop (a transform would work, too).

I believe there is a system parameter (a APT_?? variable?) that can be used to set the DataStage code page, but while we have talked about it, we have not done this so I have no specifics.

Brad.

You don't treat the whole record as packed, only the numeric fields. Typically the whole record is binary fixed length EBCDIC, then each datatype is handled separately based on the incoming datatype. An incoming char field will get converted from EBCDIC to ASCII automatically because you specified y...

I have not used the Oracle loader, but have used the Teradata and DB2 loads. They both lock the tables, not because of DataStage, but because of the underlying RDBMS utilities that are used (db2 load, Teradata FastLoad). So what does this have to do with your Oracle situation? Figure out what Oracle...

Found the reference, in fact I posted in back in April:

EBCDIC ! and ] not translated properly

The IBM site is posted there towards the bottom. It shows that code pages 037 and 500 map 4F to '|' and '!', respectively, and to 5A to '!' and ']', respectively.

Hope this helps.

Brad.

I'm sorry I don't have more info, but I think it is a difference in the EBCDIC to ASCII mapping between the mapping that DS uses to convert to EBCIDC and what the mainframe is expecting. See if you can determine the codepage that DS uses for EBCDIC and compare it to the codepage used on your mainfra...

We have a team of about 15-20 developers locally and 20-30+ in India. About 75% are employees. Is there any kind of group rate available for membership? At $99 a year per membership, it adds up quickly. I have proposed to our management to come up with some way of providing membership for more of ou...

I had one of our DBAs dump some data for this table. Does anyone know the format of the locked_at column? I assume this is some kind of timestamp (or seconds/ticks from some point in time): select * from xmeta.xmetalockinfo with UR ; REPOSITORY_ID LOCKED_AT LOCKED_BY_USER LOCKED_BY_SESSION NEEDS_UPG...

Good point. I am starting a new posting to deal specifically with the trigger or any other methods to remove logical locks from the XMETALOCKINFO table:

Methods for cleaning locks in XMETALOCKINFO table

Brad.

In a past posting, we were dealing with job locks that had no corresponding OS-level processes. Turns out the locks were logged in the XMETALOCKINFO table and needed to be removed. See Unable to unlock jobs in v8 for details. I am starting a new posting to deal directly with the topic of using a tri...

Have you or anyone else seen any patches for it?

So far, we have gotten this message for UDF's and OLAP functions (ex. RANK... ORDER BY). And yes, we get the warning but it executes just fine. Thanks!

Brad.

Hmmm, so I could declare it a varchar(19) - since the timestamp would be 19 bytes - and use a null field length of '' to catch when it should be null, then convert with a modify.

Sounds like a plan. Thanks!

Brad

How do I import a nullable timestamp field? For the sake of conversation, assume the record is an integer, timestamp, and a char: 12345||"Joe Smith" So, the timestamp field we recieve from our source is either the full tiemstamp (19 bytes) or an empty set. I tried setting the null_value to...

We have a SQL query that we are running using the Teradata Connector stage. The SQL calls a UDF (user defined function) to format one of the columns. The query runs fine from other tools, and the job executes fine. However, there is a warning sign next to the SQL property in the TD Conn stage: Inval...

Do you have copies of the triggers that you can post or send to me or pseudo-code? I am guessing I am not the only one interested in those!

We are using DB2 for our repository. We can convert them as needed, and I can forward it to our DBA group.

Thanks!

Brad.

What triggers? Are these triggers that you or your DBA created or do they come with DataStage/WAS? I think this is exactly what we need, but I am not sure where to find the details about the triggers. Can you point us in the right direction?

Thanks!

Brad