DSXchange

The settings are:

Format:
Final Delimiter = none
Record Delimiter = UNIX newline

Field Defaults
Delimiter = Comma
Quote = double

All 'Varchar' are set as Extended = 'Unicode'

We are talking about a Unix file.
thanksss

Hi Chulett. The file is not a fixed-width one, it has delimiters between the fields. Follow the file structure: FIELD 1 ... integer (10) FIELD 2 ... char (25) - changed to 'varchar' FIELD 3 ... varchar (40) FIELD 4 ... integer (10) FIELD 5 ... char(15) - changed to 'varchar' FIELD 6 ... decimal (13,...

Tks friend.

Can I do it inside the transformer, can I use this function inside the transformer?

I thought about read the universe table DS_JOBS through The stage Universe and then use this function inside the transformer, informing the jobname as the parameter.

Tksss!!

Best regards,

Thank you, Chulett.
I marked this topic as 'Resolved'.

Best regards,

I left it off and now the messages are: "Invalid SQL SELECT statement was entered"; "INSERT INTO DW.LKP_AREA_ATUAC_FUNC (func_area_atuac_cod,func_area_atuac_des) VALUES (99,'CANTINA') teste..Oracle_OCI_26.DSLink1: DSP.Open GCI $DSP.Open error -100."; "Attempting to Cleanup a...

A FILE??

Do u think it is possible to execute an statement written in a Sequential File, for example?

Even it is a SQL and not PL/SQL. SQL is also interesting.
How would I do that?

Tkssssss a lot!!

Yeah, you are right, Chulett.

Actually my colleague would like to read a file - where the cursor statement was written in - and execute it somehow at the DataStage.

Do u think it is possible?

Thank you!!

Hi Guys, At the end of the story, I created a routine which counts the number of delimiters in a list and sums one. Example: Joyce, John, Mary Delimiters = 2 (+1) = "3" Then, I wrote a FOR loop starting from 1 and going until Delimiters quantity. Inside de Loop, it generates a string and b...

Hello Guys!!! I found what was wrong!!!!!!! The parameter name was invalid actually. The parameter name is "MAXFETCHBUFF" and not "MAXFETCHBUFF SIZE "!! Now my job is running OK. Thanks for your help, Ray. My uvodbc.config is: [ODBC DATA SOURCES] <localuv> DBMSTYPE = UNIVERSE net...

Ray, I wrote in the uvodbc.config: [ODBC DATA SOURCES] <localuv> DBMSTYPE = UNIVERSE network = TCP/IP service = uvserver host = 127.0.0.1 MAXFETCHBUFFSIZE = 16384 The error when I read my UV Query now is: DSD.BCIConnect connecting to localuv, call to SQLConnect failed. SQLSTATE=IM997, DBMS.CODE=0 [D...

Oh ... really?


Do you know if there is another one with this features available in 7.x version?
I mean, one that describes the Table definition?

Thank you.

Best regards,

Hello my friend. When I use the DSGetLinkMetaData function, it shows the following message: Array 'DSGetLinkMetaData' never dimensioned. 1 Errors detected, No Object Code Produced. Do you know what is happening? Is it necessary to mention a library like: $INCLUDE DSINCLUDE JOBCONTROL.H ?? Best Regar...

Actually I think I was not clear and you didnt get it. When the routine is called for the third time, the last register inserted is updated, and it happens every time the routine is called. In short, the file has always only two registers. Even if I call it thousand of times. Ex. If I call the routi...

Hey my friend,

I did a copy of my job and rescheduled it.
it worked.

Best Regards,

ray.wurlod wrote:

Code: Select all

SELECT MESSAGE FROM SYS.MESSAGE WHERE @ID = '020548';

reveals that this code is the generic message "Aborting", which doesn't help very much.

My friend,
Thank you for your help!!
Yeap, the message is not that clear, I agree. Actually is not clear at all.

Best Regards,