DSXchange

DS_FocusGroup

thanks i like the trick ! .. and yes fingers crossed then :D

DS_FocusGroup

Can someone please let me know how to schedule a job in datastage on an hourly basis? i.e. run a particular job everyday but every two hours.

Thanks

DS_FocusGroup

yes the awk is accesible from DS as i am running another awk in some job. the problem i see is that its putting extra single quotes around the '"{if (NF==3) print $0}"' . If i use double quotes it puts extra single quotes around :roll: Not sure why ? as i have tried without any quotes but ...

DS_FocusGroup

Command failed to execute - Missing field separator '"{if (NF==3) print $0}"' is not recognized as an internal or external command, operable program or batch file.

Thanks

DS_FocusGroup

on windows.........

DS_FocusGroup

Hi,

I am trying to run an awk command in datastage through command stage. The command run fines if i run it on DOS command prompt but when i run it in DS its giving me an error. Its a pipe delimited file

Code: Select all


awk -F "|"  '{if (NF==3) print $0}' source file > output_file

Thanks.

DS_FocusGroup

the NLS mapping had to be set to project default!!

DS_FocusGroup

i have also looked in the RT_BP2927 file of the job. nothing there on line 122.

DS_FocusGroup

OK i have looked into the background of what a phantom error is and tried a few solutions posted on this site but i am still getting these in my teradata load jobs (Multiload). DataStage Job 2927 Phantom 7524 Program "DSP.Open": Line 122, Exception raised in GCI subroutine: Access violatio...

DS_FocusGroup

OK i guess we cannot do

Code: Select all

SPECIFICATION= KEEP NEW_A= OLD_A

so i dont know now whats wrong with it. as i have 29 columns in the source file before the modify stage and in the modify stage all i am doing is renaming these columns. All the new column names are present in the output definition

DS_FocusGroup

Ok now i have done something like this in the modify stage:

SPECIFICATION= KEEP NEW_A= OLD_A
SPECIFICATION= KEEP NEW_B= OLD_B

i am getting the following error

Code: Select all

Expected ';' or ','; got: "="; input: 
KEEP NEW_A=OLD_A ;
;
KEEP NEW_B= OLD_B;
;

DS_FocusGroup

i will have a look into this. although i doubt this can be a problem as i have just changed the database stage from DB2 to teradata and the rest of the design is the same which was functional.

thanks though

DS_FocusGroup

i am getting several warnings like this while performing sparse lookup from teradata using TPT. AcctArrg_Lkup3: Schema field A in input data set 0 not present in design time information. Extended field properties for this field will not be available. AcctArrg_Lkup3: When checking operator: The modif...

DS_FocusGroup

i think you need to check first line columns names to true so you can properly read the records.

and if you need to capture the rejects from Db2 i think you can drag a reject link out of it

DS_FocusGroup

I am fetching rows from the database and writing it to a dataset with copy stage in the middle. the SQL select gives the following result Column1 Column2 997000045147278 223319.43 in the dataset when i view the data its shown like: Column1 Column2 997000045147278 0000000223319.43 zeros are being add...

DSXchange

Search found 197 matches

Scheduling a Job every Two hours?

Error Running AWK

Phantom 7524

Lookup warnings in TPT

Display Problems