DSXchange

altruist

Hi,

Can anyone let me know who we could write messages from C++ routine to datastage logs

altruist

Hi,

I am creating generic jobs for various purposes, however, I am concerned about the Job id that gets assigned to the multiple instances.

Will all invocations of a job pick the same job id ? If so, I might exceed limits on RT_LOGxxx table

altruist

Hi,

I am trying to obtain log for Command/Routine activities within a sequence. Can you please let me know how we could do this using dsjob -logdetail command.

altruist

Hi,

I want to find out whether the name passed as an argument is a sequence or a datastage job. Can you please tell me how we can do this through unix.

Thanks & Regards

altruist

if IsValid('Timestamp',field(DSLink.INPUT,'.',1)) and IsValid('int64',field(DSLink.INPUT,'.',2)) and len(field(DSLink.INPUT,'.',2)) <= 6 then @TRUE else @FALSE IsValid('Time',DSLINK.INPUT) if IsValid('Time',field(DSLink.INPUT,'.',1)) and IsValid('int64',field(DSLink.INPUT,'.',2)) and len(field(DSLi...

altruist

This is what I found in the documentation for IsValid Description: Return whether the given string is valid for the given type. Valid types are ″date″, ″decimal″, ″dfloat″, ″sfloat″, ″int8″, ″uint8″, ″int16″, ″uint16″, ″int32″, ″uint32″, ″int64″, ″uint64″, ″raw″, ″string″, ″time″, ″timestamp″. ″ustr...

altruist

IsValid is not taking three arguments. I am using Datastage 8.1

altruist

Hi,

How can we check the validity of the below fields coming in as string from source

Code: Select all

Timestamp  --- IsValid('TIMESTAMP',InputField)
Timestamp (Microseconds)
Time
Time (Microseconds)

Thanks & Regards

altruist

Thanks stuart, I was hitting the 8.5 repository until now. I have obtained the credentials of 9.1 and as you mentioned it is working fine now.

altruist

The XMETA tables that I am using are correct. I have basically queried all the XMETA tables start with DATASTAGEX_XMETAGEN%.

We have 8.5 and 9.1 on same server. Could this be causing any issues ?

altruist

Sorry I have missed the query

Code: Select all

SELECT * FROM XMETA.DATASTAGEX_XMETAGEN_DSPROJECTC2E76D84;

Not just this table, but in other XMETA tables as well, I only see information about default projects (ANALYZERPROJECT and dstage) [I have enabled OR Logging in administrator v9.1]

altruist

Thanks its working :D

altruist

Hi, We had an itag installation of 8.5 and 9.1 This is the first time I am using Information Analyzer. I am currently trying to perform column analysis using DS9.1 and getting the below error. Unable to validate DSOptions: missing username Analysis Settings seems to be fine, I have verified the belo...

altruist

My apologies, restarting ASBNode solved the issue.

altruist

ISSUE: : Now I am able to import metadata definitions, but not able to connect through oracle connector. While connecting I am specifying Client version as 11g. ERROR: Error loading connector library libccora11g.so. Could not load module /opt/IBM91/InformationServer/Server/DSComponents/bin/libccora...

DSXchange

Search found 74 matches

datastage log with C++

Job ID for Multiple Instances

dsjob -logdetail for Command/Routine Activity

Identify sequence/job

IsValid for Time

Column Analysis or any analysis fails