DSXchange

Hi, I am combining first 10 records in transformer.Below is the logic:- 1. running below command in sequential file stage:- head -10 <FileName>.* Created sequence number column in sequential file stage. 2. Created stage variable and merged all 10 records in one column. Svar=Svar:Inputcolumn.Payload:...

Hi Chullet,

Thanks for your input,as far as i know it is BLOB column and they are asking me to pass top ten rows from file to this blob.

Hi priyadarshikunal I am not able to connect to server from any client machine. Is it a new installation? No i am working on this server since last oct. Were you able to connect to the server before this issue popped up? Yes Did you do any authentication type changes in the server such as OS authent...

I am able to login to server using xmeta userid and password and was is also running.

Can't i convert the string input data into HEX( using basic transformer stage) and pass as binary large object to SP?

Hi, I am unable to connect to datastage server when i login to client i get below error:- :- Failed to authenticate the current user against the selected Domain: Session id for principal [username] is null. Either the client is not using the ASB authentication service, or your server JAAS configurat...

If it is CLOB what datatype i need to define in datastage to pass it through SP..?

I am combining all 10 records(which is not blob rather a pipe delimited or fixed width file) in transformer and want to pass it to stored procedure as a blob.

Hi, I am in datastage 8.7 and i have requirement where i need to pass value to stored procedure which is defined as BLOB. I have source as sequential file and i need to pass first 10 lines of sequential file to stored procedure whose parameter is blob define.I tried giving input to procedure as long...

Hi, I have a job where i am generating GUUID using java call and storing into dataset and GUUID need to be passed in where clause of another job,so is there any way i can pass this dataset value as a parameter to another job. I know after storing this value in file(sequential file) i can pass but i ...

Instead of calling stored procedure i am running PL/SQL block in Oracle connector stage and comming at the end. Below is the code,how can i abort a job in case RetVal <>0? DECLARE RetVal NUMBER; P_PAYLOAD str_payloads.payload%type; P_PAYLOADHASH VARCHAR2(200); P_TIMESTAMP VARCHAR2(32767); P_PAYLOADS...

At end of the job.

Hi,

I have a requirement where i have been given a stored procedure (Transform) and i have been told that i need to commit the procedure once it finishes successfully.

Is there any way in Stored proc stage or any other way i can achieve this?

1. Using vi editor
2. Without using vi editor.

Hi Arnd,

Thanks for your reply.Its working fine