DSXchange

Hi, I am using AIX server, in which datastage v8.1 is installed. I have a scenario that while developing the PX jobs i used 2 node configuration. Now i want the jobs to run on 4 node configuration due to performance enhancements. So, If i change the configuration file to 4 node, then will i get any ...

HI,

I have a timestamp field which has values
'2010-01-10 06.01.00.00'
'2010-01-10 05.01.00.00' .
From the above i have to subtract 5 hours. so my o/p should look like as below:
'2010-01-10 01.01.00.00'
'2010-01-09 19.01.00.00'.
please help me in achieving this.

Thanks In Advance
kamal

So you are saying that datastage cannot read the text file if its size is more than 2gb.

DSXRAG wrote:Yes as far as I know the Size limit is 2 GB.

Thanks
Rag

Hi,

Can sequential file stage in PX jobs read the text file whose size is more than 2GB.

Is there any size limit for the sequential stage to read the data?

Thanks in Advance,
K.K

Hi murali, when i tried the first job that you gave in job design, it i sthrowing the below warning: Input dataset does not have field: "accno" Thanks G.k.K You probably need a Split Vector stage. Check out the stages in the Restructure folder. ... Hi Ray, please verify the below informati...

Hi, I am facing the following warning in my job: Sequential_File_11: When checking operator: A sequential operator cannot preserve the partitioning of the parallel data set on input port 0. The job flow is seq-->Trnf--->Aggr---->Trnf--->Seq please help me in clearing this warning Thanks In Advance G...

The error is not, as I had somehow thought from the error message, in the configuration file. What flavor of UNIX are you working on, while the posted suggestion should work I've never had to explicitly set this value as normally the working directory value is set correctly by the OS. I am working ...

I suspect the answer lies in your APT_CONFIG file, please post it. ... please find the below configuration file that i used in datastage 7.5.2: { node "node1" { fastname "nt1" pools "" resource disk "/opt/Ascential/DataStage/Datasets" {pools ""} res...

ArndW wrote:I suspect the answer lies in your APT_CONFIG file, please post it. ...

Thanks ArndW for reply, can you please say how do i have to fix this issue.

Thanks
G.K.K

Sainath.Srinivasan wrote:There is no pre-built parallel stage that can read hashed files.

You can either use server activities or convert the hashed file into a dataset or similar. ...

Thanks for your reply,
How we can achieve hash file functionality in parallel jobs?

Thanks in Advance
G.K.K

Hi, I am getting the below warning message for every job that i execute in parallel, please help me in fixing it. main_program: Warning: the value of the PWD environment variable (/opt/Ascential/DataStage/DSEngine) does not appear to be a synonym for the current working directory (/opt/Ascential/Dat...

Hi, I am migrating some server jobs to parallel jobs. I have a below scenario : I have a server job which creates hash file, i want to use this hash file in parallel job as a source/lookup. which parallel stage reads the hash file created by server? Please advise me to get out of this hurdle. Thanks...

Hi chulett, i am pasting the summary log that was generated by the job sequence, my execute command stage naming conventions are , 1.Execute_Command_EVENT_COMMENT 2.Execute_Command_EVENT_STATUS 3.Execute_Command_OBJECT_VERB 4.Execute_Command_OBJECT_NAME 5.Execute_Command_CONNECTOR_ID 6.Execute_Comm...

Doesn't matter, integer or string it will work. Post the log message where it shows the command being run, it will list the 'Output from command' as well. I'll wager it's not what you think it is. Hi chulett, i am pasting the summary log that was generated by the job sequence, my execute command st...

Doesn't matter, integer or string it will work. Post the log message where it shows the command being run, it will list the 'Output from command' as well. I'll wager it's not what you think it is. Hi chulett, i am pasting the summary log that was generated by the job sequence, my execute command st...