DSXchange

Use the Iconv / OConv functions to convert the date into the date format that you need.

See that the directory structures are the same across the environments like Dev / Test / Prod. If the parameters are common across all the jobs in your project , create Project Level Parameters using the Administrator and set $PROJDEF to those parameters as default values. This way , if the environm...

We need to install the LDAP client and servers on the AIX box and configure the system to accept the LDAP users which we currently working upon.
Will post you all once we are successful.


Thanks,
Phani

What error are you getting when you try to view the data from OCI stage. Try connecting from the ETL server to the oracle database from the command line. Check whether the dsenv file on DataStage server is updated with the Oracle Home and the library files which will be used to access ORA db. Ensure...

Hi , What teradata utility are using to read the data from teradata. Check whether proper Database Name and other properties in Teradata Stage are mentioned appropriately. If using Fast Export Stage , unselect the " Use Large File AXSMOD of FastExport " on the General tab. Thanks, Phani

We can assign LDAP users to a group and assign this group to DataStage group to access the jobs.

Thanks,
Phani

Hi, We are trying to load data into teradata using Teradata plugin. We are using TPUMP to load the data. Job is running fine if it has to process more than 10 records. Sometimes , as part of delta process it is possible for the job to process less than 10 records. At this point of time , the job is ...

Hi Ray,
Partitioning is set to Auto .
It tried with hash partitioning on the reference link and Auto on Primary link.
Tried with setting the preserve partioning to clear.

But no luck.

HI , I am also getting the same error and not getting cleared if I set the preserve partitioning as clear. Job design as below. DataSet | | | Dataset -------->LookupStage ----------> Transformer -----------> DataSet I am getting the same error if the source is a sequential file . How can we resolve ...

Hi , Once you log onto UV account using ./bin/dssh you need to logto the project by issuing LOGTO <projectname> Now login into the ETL box through Telnet and issue the command dslictool. You will be able to see that a PID is listed and the license is being utilized. But when you login through design...

Hi , I understand that using dslictool , we can find the number of licenses being used by datastage. But I believe it is not working as supposed to. When I logged into the corresponding project through dssh ( UV environment ) , I found that 1 license is being utilized otherwise I am getting the belo...

Hi,
How to get the first event id that is getting generated for a particular job.
The last event we can capture using the DSGetNewestLogId.
Is there any way to capture the first eventid generated.

Thanks,
Phani

Hi Ray, When we use DSGetLogSummary , I understand that it will only read the log that got generated. So in that case , how can we read the log which is having linebreaks in it. Is there any way to capture the Message ID through which we can capture the message and then do convert on char(10), @VM e...

Hi,
I am able to get the log with DSGetLogSummary.
I find that there are some line breaks for a log event which I am not able to read.
Is there any way to eliminate the explicit line breaks and read the log in detail.

Thanks,
Phani

Thanks Ray,

Can you please provide some information on how to strip out the line breaks in message handler.

I want to enable this at the project level.
As of now that option is disabled in the Message Handler management. Do I need to have admin privilege to do that.


Thanks,
Phani