DSXchange

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..??

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..??

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

select XMETA_CREATION_TIMESTAMP_XMETA from XMETA.AGENT_XMETAGEN_NAMEVALUE5874305

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.

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|X...

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

Thanks for your quick responce, Just i have checked one random table and found that the datatype of timestamp is bigint describe table XMETA.AGENT_XMETAGEN_NAMEVALUE5874305 Column Type Type name schema name Length Scale Nulls ------------------------------ --------- ------------------ -------- -----...

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

So, did you check if there is any another file with similar file mask as specified in previous directory. But being similar, should be added up to the existing file though. If you put your file back to the earliar directory gives you only 3 record? Yes...when i am putting file back to earlier direc...

When i copied that file to some other path,and i read this file using same file pattern,it is able to read all four records......

Hi I want to add more on this:- I m reading source file as a parameter like PQE*MNI*.#PARAM1#.*.2010-06-10 In this case its reading only three records of type "CUST_TYPE" But when i m hardcording the filename its reading all the records from the file. Please suggest me what could be a reas...

Hi All, I have very simple dimension job whose source is sequencial file.Sequencial file has data like:- "CUST_TYPE","E","Existing","N/A" "CUST_TYPE","P","Prospect","N/A" "CUST_TYPE","O","Others&...

Hi Exact command is echo "X|`ls -l {file name for which counts are required}|wc -l|bc`" Hi Everyone, My design is FF -------- XFM-------------FF In my transformer i am deriving some columns and in one of the column I need the count of the source file.Without using aggragater can i achieve ...

Set your null field value to " " (6 spaces). Your message comes from the fact that your null field specification and actual field lengths are not the same. Thanks for your reply,but i have other columns whose datatype is Char of 2 lenght and others have char(6), so how can i handle null i...

Hi All, Acutally we are trying to remove warning from the jobs and most of our tagets are DB2 Enterprise Stages and we have reject links for Target DB2 and reject records if any,goes to seq. Flie Stage. Here in Seq file we are facing warning and unable to remove,its related to null handling and i m ...