DSXchange

No-one except gomers like us would use command line ftp from a Windows box. :wink: Here, any business type folk who provide Excel csv files (typically) via ftp all use some sort of GUI package... and for that same reason we practically always get DOS files as a result. Go figure. Well, I have alway...

Don't know if it exists on Linux or not. But even if it does, it may be in a directory not mentioned in your PATH environment variable (which specifies the directories to be searched when looking for ... Command : dos2unix file.csv file2.csv Error: dos2unix: converting file file.csv to UNIX format ...

Hi All, I use dos2unix to convert source files on the windows machine to unix file on a SunSolaris machine. After which I can process the file without the option "Record Delimitor String = Dos format". on the sequential file stage But dos2unix does not seem to work on a Linux box. Has anyo...

Hi All, The Oracle table that I load into has a column of datatype Number(). No scale or precision is defined. The precision p can range from 1 to 38. The scale s can range from -84 to 127. I used float in Datastage to load data into the table. But the values loaded was not as expected source value ...

I was searching for a solution on a similar problem and found this post. In my experiance the job still throws warnings even when there is a reject link! Would that be right or am i doing something wrong. Hi madhur, Can you be clear whether your balnk line means something like this XXXXXXXXXXXXXXXXX...

It should come under Processing stages when you install Datastage. I have version 7.5.1.A and I see it in my pallette. sorry to come back to the topic after a long time. We use 7.5.1.A, but the SERVER component is not available to us [we develop jobs only on parallel]. Is that why I do not get to s...

ray.wurlod wrote:Looks like a job for a Pivot stage following a Transformer stage to me. ...

Maybe its a really dumb Q!!

But how will I get Pivot on the pallete for Parallel.

and I would like to add one more hitch to the scenario. The number of columns are not fixed.

samba wrote:sonia,

You can do it like this, Source file/table after that transformer hardcode the column names in that transformer and use the pivot stage.


source -----> transform -------> pivot stage ----->

Thanks

In parallel ?

Hi, I have a source file with data that has been laid out in a cross tab format; variable number of rows and columns. eg ********* Name1 Name2 Name3 Date1 Address11 Address21 Address31 Date2 Address12 Address22 Address31 Date3 Address13 Address22 Address31 I need to convert it to Date1 Name1 Address...

Derivation field will be in transformer if u r using one. No I do not have a transformaer stage. And the issue is at the ODBC stage, when I try to view data / run the job I asked the DBA to change column definition from Column A to ColumnA. But was wondering whether there was a way to do it otherwi...

Can you enclose the column name in double quotes in the Derivation field? "Column A" ... 1. I am using an ODBC stage and in which the column derivation field is not editable nor I could find a "derivation" column as in the Stored Proc Stage. 2. I did not find anything in the &qu...

If you import the stored procedure definition you will have a "table definition" through which you can refer to the record structure processed by the stored procedure. After that it should be straigh ... Hi Ray, Sorry not a premium member 1. I imported the structure of the SP. I imported ...

Hi all,

I have a stored procedure that as a column defined as 'Column A'

eg. select field as 'Column A' from table

How can I refer to this column in my ODBC stage that calls the Procedure?

regards
Sonia

Hi, I have 2 jobs, JOB1, JOB2 that need to run sequentially. I have a PROCESS P1 that runs after JOB1 and before JOB2. I need to wait till P1 completes to trigger JOB2. No, P1 is not a DS job. To know whether P1 has completed, I need to query agaisnt table to check for complete flag. We have written...

sonia jacob wrote:

ray.wurlod wrote:Because it needs to determine/verify from this table how the partitioning of the table is organized (or, indeed, if there is any). ...

Are there other system tables that DS would need select access to?

Thanks