DSXchange

hi,
i have one question on configuration
we have
10 resource
3 applications are running on that server(server is on windows)

so what is the minimum configuration required.

datastage 8.1 version
could anybody please help me on this

thanks in advance.

ray.wurlod wrote:To expand, generate regular integers, then transform them to strings with a function such as

Code: Select all

Right(Str("0",16):InLink.MyInteger, 16)

For improved performa ...

thanks for your reply
let me check.

i want to populate the 16 digit incremental number for one column.
column datatype is varchar
how to generate the 16 digit number in the datastage

anyone please help me.
Thanks in advance

Sainath.Srinivasan wrote:The format must be

Code: Select all

%yyyy-%mm-%dd %hh:%nn:%ss

thanks for your reply
i have given like this
StringToTimestamp(lk_read.sheet,"yyyy-mm-dd hh:nn:ss")
i was tried with this %yyyy-%mm-%dd %hh:%nn:%ss,but its not accepting.so please sugget me how to do this

thanks in advance for your help.

hi, my input column:doc_guid datatype :varchar I want to insert this value into target StringToTimestamp(lk_read.sheet,"yyyy-mm-dd hh:nn:ss") i want to implement this in transformer. I am getting below error APT_CombinedOperatorController,0: Caught exception from runLocally(): APT_ParseErr...

Which "Oracle stage" are you using? Have you used them before so you know they should work or is this your first attempt? What exact 8.x release? ... thanks for u r reply. i am using oracle enterprises as target in 8.1 version. i have used oracle enterprise edition as a source,that time i...

Which "Oracle stage" are you using? Have you used them before so you know they should work or is this your first attempt? What exact 8.x release? ... thanks for u r reply. i am using oracle enterprises as target in 8.1 version. i have used oracle enterprise edition as a source,that time i...

Sainath.Srinivasan wrote:Try to view the corresponding osh script.

Also check the response from view data. That may give you hint about any parameters or missing values.

Can you see the values correctly in the connecti ...

my job is got aborted,so i am unable to view the OSh code.Oracle stage is my target.

DataStage is having problem when attempting to decrypt your connection details. Either you have provided blank or invalid characters in your username (or password) or using reserved words such as ' ... THanks for reply. I have given below details user name:V8USER password:V8USER server:test.uk tabl...

Hi, I am getting following error when i load the data into oracle table.I have given Username ,password and servername. Error occurred during initializeFromArgs(). Incorrect dboptions option list; it failed on Expected "," or "}", got: "USER", line 1. A user name is req...

Sainath.Srinivasan wrote:

pavankatra wrote: So what i need to do to resolve this issue,please suggest me.why because i was strucked.It is almost end of the project.

Is this the only table in your entire projec ...

no,i am loading the data into 3 tables.It is my last step thats why i asked you like that.

Thanks in advance.

just change extention from '.log' to '.ctl' in the file name mentioned. Thats the SQL Loader control file, check that file. Thanks for your help. There we have two files one is with ".log" and secon one is ".ctl" So what i need to do to resolve this issue,please suggest me.why b...

Sainath.Srinivasan wrote:Check the corresponding ctl file. ...

I am sorry, i didnt get what you are saying.Can you please ellobrate what is ctl file and how to check that ctl file.

thanks for your reply.

ray.wurlod wrote:Use StringToDate() to convert to binary date format, and DateToString() to convert back to desired format. Use appropriate date format strings for each function. ...

thanks for your reply.

problem solved.

i have created stagvariables to resolve this.

Thanks for your suggestions.

Oracle enterprise stage calls the oracle sqlldr when the mode is 'Load'. Since its not native to Datastage the errors are stored in log files. So, Please check the file C:/IBM/InformationServer/Server/Scratch/ora.6172.514000.1.log for errors. thanks for your reply. Oracle_Enterprise_20,0: SQL*Loade...