user information in ds 8.1

meet_deb85 · Post by **meet_deb85** » Tue Jul 13, 2010 12:28 pm

Hi All,

can anyone tell me the that in datastage 8.1 which table stores all user created information with date and timestamp.

I think it is store in XMETA database but dont know the table name.

Please help me to get this info.

Thanks

chulett · Post by **chulett** » Tue Jul 13, 2010 1:06 pm

Do you mean when the users themselves were created, or when those users have created something else, jobs for example? What kind of 'number' are you seeing?

meet_deb85 · Post by **meet_deb85** » Tue Jul 13, 2010 1:14 pm

Thanks for your quick responce,

Just i have checked one random table and found that the datatype of timestamp is bigint

Code: Select all

describe table XMETA.AGENT_XMETAGEN_NAMEVALUE5874305

Column                         Type      Type
name                           schema    name               Length   Scale Nulls
------------------------------ --------- ------------------ -------- ----- ------
XMETA_CREATION_TIMESTAMP_XMETA SYSIBM    BIGINT                 8      0    Yes

And i want those userid's date of creation who is accessing the datastage like creating jobs and those who is accessing information server.

meet_deb85 · Post by **meet_deb85** » Tue Jul 13, 2010 2:09 pm

Please help me to get date value.. is there any conversion function??

chulett · Post by **chulett** » Tue Jul 13, 2010 2:14 pm

No clue as you haven't let us know what database you are using for XMETA storage, nor provided any samples of what they look like.

meet_deb85 · Post by **meet_deb85** » Tue Jul 13, 2010 2:25 pm

chulett wrote:No clue as you haven't let us know what database you are using for XMETA storage, nor provided any samples of what they look like. ...

Hi,

XMETA is stored on Oracle database and here i m giving u the sample.

XMETA_CREATED_BY_USER_XMETA|XMETA_CREATION_TIMESTAMP_XMETA|XMETAMODIFICATIONTIMESTAMPXMET|XMETA_MODIFIED_BY_USER_XMETA
SRVLAJ-DSADMIN|12,65,16,54,66,361|12,76,28,19,56,971|KALLAS01

Here 12,65,16,54,66,361 value is in integer and i want a date format.

Is it possible to get date format?

chulett · Post by **chulett** » Tue Jul 13, 2010 2:27 pm

I'm sorry but how is "12,65,16,54,66,361" any kind of an integer? How did you select this value?

meet_deb85 · Post by **meet_deb85** » Tue Jul 13, 2010 2:38 pm

chulett wrote:I'm sorry but how is "12,65,16,54,66,361" any kind of an integer? How did you select this value? ...

Yes that's interesting.

I dont know but in table structure also its coming as Bigint....

but it should be as timestamp.I was asked to get a date from this bigint value.

chulett · Post by **chulett** » Tue Jul 13, 2010 2:45 pm

Please answer the second question.

meet_deb85 · Post by **meet_deb85** » Tue Jul 13, 2010 3:08 pm

chulett wrote:Please answer the second question. ...

select XMETA_CREATION_TIMESTAMP_XMETA from XMETA.AGENT_XMETAGEN_NAMEVALUE5874305

meet_deb85 · Post by **meet_deb85** » Tue Jul 13, 2010 9:13 pm

meet_deb85 wrote:
chulett wrote:Please answer the second question. ...

select XMETA_CREATION_TIMESTAMP_XMETA from XMETA.AGENT_XMETAGEN_NAMEVALUE5874305

can someone tell me how to get date of creation of userid's..??

meet_deb85 · Post by **meet_deb85** » Wed Jul 14, 2010 4:03 am

meet_deb85 wrote:
meet_deb85 wrote:
chulett wrote:Please answer the second question. ...

select XMETA_CREATION_TIMESTAMP_XMETA from XMETA.AGENT_XMETAGEN_NAMEVALUE5874305
can someone tell me how to get date of creation of userid's..??

Is it a bug or is there some rules for conversion,please tell me..??

chulett · Post by **chulett** » Wed Jul 14, 2010 5:59 am

If someone knows, they would post. Be a little more patient.

I, for example, have no clue and no direct access to do any investigation on my own. Why run open a case with your official support provider and ask them?

priyadarshikunal · Post by **priyadarshikunal** » Wed Jul 14, 2010 8:25 am

This seems like unix timestamp to me, have you tried adding that number of milli seconds to 01-01-1970? 12,65,16,54,66,361 seems to be 03-02-2010 02:51:06.361